Re: Accessing other Tablespace

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.

Any idea, whats wrong?

Thanks,

Chris Received on Sat Jun 24 2006 - 06:45:44 CDT