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

Miklo,

Although you may be looking at the right tablespace, the table itself is owned by system still. For bill to see it, try:

select * from system.test

alternatively, if you want bill to always see it like the table is his own, when logged in as bill, you can create an alias (synonym) to the table: create synonym test for system.test;

then bill can do the standard select * from test

Good luck,
Bryan

"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 - 07:59:49 CDT