Re: User privileges - should be easy!

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Wed, 22 Jul 1998 22:39:08 GMT
Message-ID: <35b76997.38578012_at_dcsun4.us.oracle.com>


On Wed, 22 Jul 1998 16:08:35 -0400, Tim Brett <tbrett_at_nortel.ca> wrote:

>Hi,
>
>I am trying out my newly installed Oracle8 on windows NT.
>I startup sql*plus using system account:
>
>Connected to:
>Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production
>PL/SQL Release 8.0.4.0.0 - Production
>
>SQL> create user tbrett identified by mother;
>
>User created.
>
>SQL> grant create session to tbrett;
>
>Grant succeeded.
>
>SQL> create table test (this_is_a integer);
>
>Table created.
>
>SQL> grant select any table to tbrett;
>
>Grant succeeded.
>
>QL> grant all on test to tbrett;
>
>Grant succeeded.
>
>Now I startup sql*plus as tbrett to the same service:
>
>Connected to:
>Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production
>PL/SQL Release 8.0.4.0.0 - Production
>
>SQL> select * from test;
>select * from test
> *
>ERROR at line 1:
>ORA-00942: table or view does not exist
>
>What gives??????

Try

select * from system.test;

Since tbrett does not own it and no synonym exists for it, you need to prefix the table ( or any object ) with the owner.

>
>Thanks in advance,
>Tim.
Received on Thu Jul 23 1998 - 00:39:08 CEST

Original text of this message