| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie SQL*plus (stupid question???)
Hi Miklo
On Tue, 25 Sep 2001 13:39:52 +0200, "Miklo" <jha_at_xs4all.nl> wrote:
>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).
The BILL schema does not know where to find the TEST table. Try "select * from system.test". Or you can set up a synonym in BILL that makes TEST in BILL point at SYSTEM.TEST. Another option is to set up a PUBLIC synonym in system that makes every schema that does not have a TEST table (or view) reference SYSTEM.TEST.
Regards
Dale
 |
 |