Hi,
despite of granting dba to bill the owner of test table is still system
user.
You have to use full table name with the owner of the table:
"select * from SYSTEM.test"
HTH,
Ales
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:01:53 CDT
