User privileges - should be easy!

[Quoted] [Quoted] 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. Received on Wed Jul 22 1998 - 22:08:35 CEST