Re: tablespace question.

Hi Song Zhang,

comments embedded...

"Song Zhang" <sozst1_at_hotmail.com> wrote...
> 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);

Which user creates this table?

>
> 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;

DEFAULT TABLESPACE SYSTEM??? *N*E*V*E*R do that!

> grant connect to abc;
> grant select on cde to abc;
>
> Then I log on sqlplus and got the following error.
> select * from cde;

Should be: select * from <user_who_created_table>.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
>

Greetings,
Guido Received on Fri Feb 14 2003 - 09:39:31 CET