How to enable Powerbuilder users Oracle

Hi Rae,

If you are using pfc Administration then you can adjust user in this tool.

You can also look in the system tables. In the Database painter in the 'select tables'  window checked the check button system tables and look in tables sys.user_?? may will help you. I don't know which table.

What doesn't run? Connect returns error, or tables are not accessible? In both cases, PB doesn't maintain any tables for connection. If You cannot connect, check what is in sqlca properties before connect statement.

Hi,

1. this is the place where Oracle store connection information (it might be a little different):
  C:\ORANT\NETWORK\ADMIN\TNSNAMES.ORA

2. PB uses DataBase profile (accessed from menu),
where you specify login information;
try to connect using connect button, if it is OK - it should be OK in the application.

3. If the problem is while executing SQL statement,
you have to look at the SQLCA.SQLCode value,
and dealing with particular problem.

Locate the problem first.
Lev

To Clarify:

The application selects and displays data from an Oracle database.

1)  When an existing user runs the application it runs OK.

2)  When a new user runs the application,  it launches,  but does not return any data,  just a blank report.  No error messages,  just no data.

Any ideas?

What do you mean - 'new user'?
- NT login user;
- application user;

First enter the data of the new user in the list of existing user and then let the new user to run the application.
I think u know where are the existing user saved.

Levr & Bhatti:

I think we are getting somewhere!  Levr - The new users are Oracle users that are created in our main application program - Maximo.   Maximo uses Oracle security.  I don't think the NT security is relavent as it is identical for both users.

I can't see any difference in the Oracle user permissions - between old users and new users.

It sounds like Powerbuilder has its own authority scheme. How can I access the Powerbuilder users?

Rae

1. Do what:
 PB uses DataBase profile (accessed from menu),
select login information;
click Connect;
Do for both users. Succeeded on not?
try this first to see if the connection works for both users.

2. I do not think PB user is matter.
from Library painter go Source.Connect;
select PB native;
type user ID.

3. To check user ID:
check out any object;
click Check status;
will see the user ID who check out the object;
Lev

Maybe, the table select is not granted to new users. It may be granted to a group, that new users are not members of.

I think hink is on the right track.  Rights are granted by the Oracle dba  

Levr, Hink and PDC

I altered the db profile to connect as a new user. Powerbuilder responded with the message:

"Cataloge Tables could not be created and are not available for use."

Changing back to the old user,  Powerbuilder executed the connect without complaining.

Any ideas?

Great!

1. Do you connect new user as 'PB native'?

2.In the DB profile click Edit;
 - select System tab;
 - in the PowerBuilder Catalog Table Owner instead of 'SYSTEM' type DB login ID that is used on the Connection tab(first tab)

The problem is that PB doesn't allow you to connect to DB.
We need to maintain connection without running the code.
Try, this might be helpfull.

Let me know if the problem persists.
Lev

Hello Rae,

Please confirm the entry of your username and user_id in sys.all_users (systemtable).  All user using the application, their data is entered in this table. Ask for this task to your DBA.

Sorry writing again,

username mean new user. New user username and userID may some where needs PWD also.

Hello Rae,

If you add new user in the sys table all_users, please do it through the DBA. And through the sql script CREATE USER...... or someone,


Please check this this table is new user added hier through sql script moreover you need the priviliges for this user in ORACLE database.

Please Let me know you comment. THANKS.

The new users are in the all_users table.  This has to be created by the application.

Are there any special tables that Powerbuilder uses that the application may not have granted privleges to.