Re: Using PowerBuilder 3.0 make connection to Oracle?

In article <34fbea$jmf_at_hk.super.net>, reidlai_at_hk.super.net (Mr Lai Wai Kei) writes:

> I made connection to my Oracle 7.0 for Novell Netware using
> PowerBuilder Interface for Oracle (PBORA030.DLL). It works very well
> This connection was made with DBA's ID. But when I did it using other
> users' ID, a message "insufficient privilege" always appeared. Are
 there
> anyone could help me? What privilege should I assign to other users?

When you did your Powerbuilder to Oracle installation, you created 4 tables in the Oracle database that begin with PB (i.e. try a select * from sys.dba_tables where table_name like 'PB%'). Since the DBA account has select any table, update any table, etc. privileges, you would be able to get to these tables. If you want other Oracle user IDs to be able to get to these tables (which are needed to run Powerbuilder to Oracle), you would have to grant select, update and insert to a role, the individual users or to PUBLIC. Received on Tue Sep 06 1994 - 00:59:04 CEST