Re: Problem accessing Personal Oracle7 through Visual Basic

As far as I remember this 'feature' applies only to users with dba privilege. Check whether scott has dba priv (select * from session_privs in sqlplus) and if needed revoke it and attach all the tables again. This should hopefully resolve your problem

Thanks,

Sybrand Bakker, Oracle DBA

Chunangad S. Sriram wrote:

> While trying to access Personal Oracle7 with the help of Microsoft's
> ODBC driver for Oracle from Visual Basic, I encountered the following :
>
> One of the conventional users of Personal Oracle is 'scott'. By using
> the Personal Oracle Navigator, I found that 'scott' had ownership of
> tables 'EMP', 'DEPT' etc.. But when I tried to open a database from VB
> using the MS ODBC driver for Oracle with the owner name as 'Scott', I
> got to open all the tables (system tables, some of them whose names
> started with 'PUBLIC') except for those small tables 'EMP', DEPT' which
> I planned to query with SQL statements.
>
> Could anyone kindly tell me how I can get to open only the non-system
> tables which I want to perform SQL queries on ?
>
> Sriram
Received on Tue Sep 22 1998 - 13:22:16 CDT