Newbie SQL*plus (stupid question???)

Hi there,

I've got a small problem,

Logged in as user System in SQL*plus I've created:

• a table test in tablespace tenr01,
• Create user bill identified by passwrd default tablespace tenr01
• grant dba to bill;

when I excecute this query "select * from test" I get a result.....very nice

but when I logged in as user Bill and I excecute that query it says "Table or view does not exist"..
As user Bill I've got dba rights and my default tablespace is tenr01 (where table test is).

can anyone help me please!!

Greetings,
Miklo Received on Tue Sep 25 2001 - 06:39:52 CDT