Re: Create Views with object-privs from Roles

>Are object privileges via roles not valid for "create view" ?

You cannot base views on privileges obtained via a role. You can only create them based on privileges that have been directly granted.

>But this sentences in the ORA-help indicates the opposite:
>"If you revoke an object privilege on an object from a user whose schema
>contains a view on that object, Oracle invalidates the view"

That sentence is true - it assumes that the privilege was directly granted (since that's the only way to create a view on another user's object). If you own a view based on someone else's table, and your privilege on that table is revoked, then your view remains in your schema but becomes invalid.

Kevin.
now online at http://www.kevinloney.com Received on Thu Oct 01 1998 - 13:08:03 CDT