Re: tablespace question.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 14 Feb 2003 03:12:31 -0800
Message-ID: <a20d28ee.0302140312.6d512e1a_at_posting.google.com>

"Song Zhang" <sozst1_at_hotmail.com> wrote in message news:<F177PY6y72J4hPSWlEA00014857_at_hotmail.com>...
> This is a newbie of oracle dba.
>
> I created a table say cde by
> create table cde (a integer primary key);
> insert into cde values(9);
>
> and create a user with priviledge of connect to the oracle system
> and select from cde table.
>
> create user abc identified by abc
> default tablespace system;
> grant connect to abc;
> grant select on cde to abc;
>
> Then I log on sqlplus and got the following error.
> select * from cde;
> ORA-00942: table or view does not exist
>
> Thanks for the help.
>
> _________________________________________________________________
> MSN 8 with e-mail virus protection service: 2 months FREE*
> http://join.msn.com/?page=features/virus

As abc is not the owner of the table, abc needs either to issue select * from <Orig_schema>.cde;
or set up a private synonym.

[Quoted] A few other remarks

- NEVER EVER !!!!!!!!!!!!!!!!!!!!! CREATE ANY user object in the

SYSTEM tablespace and DON'T SET the default tablespace of ANY USER to SYSTEM.
- Reading at least the 'Oracle Concepts Manual' is mandatory. ORACLE != SQLSERVER. Regards

Sybrand Bakker
Senior Oracle DBA Received on Fri Feb 14 2003 - 12:12:31 CET