Help needed with granting rights

Hello,

I created a new user that called (test) has the following criteria:

      
General
Name      TEST
Profile      DEFAULT
Authentication      Password
Default Tablespace      SYSAUX
Temporary Tablespace      TEMP
Status      UNLOCK
Default Consumer Group      None
      
Roles
Role      Admin Option      Default
CONNECT      N      Y
DBA      N      Y
      
System Privileges
System Privilege      Admin Option
UNLIMITED TABLESPACE      N
      
Object Privileges
Object Privilege      Schema      Object      Grant Option
No items found      
      
      
      
Quotas
Tablespace      Quota      Value      Unit
No items found      
      
      
      
Consumer Groups Switching Privileges
Consumer Group      Admin Option
No items found      
      
Proxy Users
User
No items found
      
Proxied for Users
User
No items found

------------------

I then used this schema to create a table called TBL_TEST.

I then created another user called ANDY with following object privileges:

General
Name      ANDY
Profile      DEFAULT
Authentication      Password
Default Tablespace      DB01
Temporary Tablespace      TEMP
Status      UNLOCK
Default Consumer Group      None
      
Roles
Role      Admin Option      Default
CONNECT      N      Y
      
System Privileges
System Privilege      Admin Option
No items found      
      
Object Privileges
Object Privilege      Schema      Object      Grant Option
ALTER      TEST      TBL_TEST      N
DELETE      TEST      TBL_TEST      N
INDEX      TEST      TBL_TEST      N
INSERT      TEST      TBL_TEST      N
REFERENCES      TEST      TBL_TEST      N
SELECT      TEST      TBL_TEST      N
UPDATE      TEST      TBL_TEST      N
      
Quotas
Tablespace      Quota      Value      Unit
No items found      
      
      
      
Consumer Groups Switching Privileges
Consumer Group      Admin Option
No items found      
      
Proxy Users
User
No items found
      
Proxied for Users
User
No items found

----------------------------

I then logged on to the database with the ANDY schema and tried the following simple select statement:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> SELECT * FROM TBL_TEST;
SELECT * FROM TBL_TEST
              *
ERROR at line 1:
ORA-00942: table or view does not exist


--------------

What am I doing wrong  - do I need to assign privileges to the tablespace / datafile's in order to use SELECT on the table ??   (If I log on with the TEST schema I can view the table okay.

Thanks.
Start Free Trial