What am I missing???

From: Audun Jensen <audun_j_at_yahoo.no>
Date: 21 Feb 2001 07:01:03 GMT
Message-ID: <Xns904F5187D7C58audun.jyahoo.no@130.133.1.4>

Hi all,
I read somewhere (I think) that grants on views has to be given directly to the user and not via roles (is this true?). In order to test this I did the following (logged on as dba):

CREATE USER testuser IDENTIFIED BY testuser; ALTER USER testuser DEFAULT TABLESPACE users QUOTA UNLIMITED ON users; GRANT CONNECT TO testuser;

CREATE TABLE testtable (a VARCHAR2(4), b NUMBER(5)); INSERT INTO testtable VALUES('srrt', 45); CREATE OR REPLACE VIEW testview AS SELECT * FROM testtable;

CREATE ROLE testrole;
GRANT SELECT ON testview TO testrole;

then connect as testuser/testuser and run SELECT * FROM audunj.testview;

gives "ORA-00942: table or view does not exist"

I'm pretty sure this should work or???

AJ Received on Wed Feb 21 2001 - 01:01:03 CST