Re: User privileges - should be easy!

When you are logged in as tbrett, and try to query it does not find object ( table test ) in the same schema. So you should qualify the table test with the owner name which is system in this case.

Your query should look like this:-

select * from system.test;

Try again, and see the results.

Hope this helps,
In case you get other problems shoot me an email.

Manoj Jain
Oracle Certified Professional - DBA
Chauncey Certified Oracle7 - DBA

In article <35B646C3.1EF5_at_nortel.ca>,   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??????
>
> Thanks in advance,
> Tim.
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 23 1998 - 04:43:58 CEST