Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Accessing other Tablespace

Re: Accessing other Tablespace

From: Christian Schneider <Dudeldd_at_gmx.de>
Date: Sat, 24 Jun 2006 13:48:12 +0200
Message-ID: <449d267e$0$11065$9b4e6d93@newsread4.arcor-online.net>


Problem (Just to get to know PL/SQL and stuff):

I log in with user system and create some tables in tablespace users. Then I create 2 different users, give them the right to connect, and then I want to give them the right to do a SELECT / UPDATE / DELETE on the tables I just created.

Example:

CREATE TABLE grp(
grp VARCHAR2(80) NOT NULL,
CONSTRAINT grpPK PRIMARY KEY(grp),
TABLESPACE users;
);

CREATE USER Christian1
IDENTIFIED BY secret
DEFAULT TABLESPACE users;

CREATE USER Christian2
IDENTIFIED BY secret
DEFAULT TABLESPACE users;

GRANT CONNECT TO Christian1;
GRANT CONNECT TO Christian2;

CREATE ROLE READ;
CREATE ROLE WRITE;
CREATE ROLE EXECUTE; GRANT SELECT ON grp TO READ;
GRANT SELECT, INSERT ON grp TO WRITE;
GRANT SELECT, INSERT, UPDATE, DELETE ON grp TO EXECUTE;

GRANT SELECT, INSERT, UPDATE, DELETE ON grp TO Christian1;

GRANT READ, WRITE, EXECUTE TO Christian2;

Always throws the error:

ORA-00942: Table or view not found.



P.s.: GRANT SELECT ON SYSTEM.grp TO READ - neither works.

Any idea, whats wrong?

Thanks,

Chris Received on Sat Jun 24 2006 - 06:48:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US