Re: What am I missing???

Doh. I meatn dba_role_privs and user_role_privs ...

Myron Wintonyk wrote:

> Here's a possibility. Roles are only checked at login. If you grant a role to
>
> a user that is curently logged in, they do NOT get that role until the login
> again.
>
> I've run into this a number of times (just about an hour ago in fact).
>
> However, I'll reiterate the comment by another person. Did you grant the role?
>
> check dba_roles to be certain (select * from dba_roles where granted_role =
> 'TESTROLE';)
>
> Audun Jensen wrote:
>
> > 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 Tue Feb 27 2001 - 22:15:22 CST