Re: Newbie SQL*plus (stupid question???)

You made the table under user system so system is the owner

Look for table system.test

also, as user Bill you can create a synonym test for table system.test, so you can address it as test. You may also create a public synonym test for system.test.

hth

Marc

"Miklo" <jha_at_xs4all.nl> wrote in message news:3bb06d73$0$65654$e4fe514c_at_newszilla.xs4all.nl...
> 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 - 08:05:07 CDT