tablespace question.

From: Song Zhang <sozst1_at_hotmail.com>
Date: Fri, 14 Feb 2003 00:32:32 -0500
Message-ID: <F177PY6y72J4hPSWlEA00014857_at_hotmail.com>

[Quoted] This is a newbie of oracle dba.

[Quoted] I created a table say cde by

[Quoted]           create table cde (a integer primary key);
          insert into cde values(9);

[Quoted] 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;
[Quoted]           grant connect to abc;
          grant select on cde to abc;

Then I log on sqlplus and got the following error.
          select * from cde;
[Quoted]           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 Received on Fri Feb 14 2003 - 06:32:32 CET