Re: query that will simply return all Oracle role/permissions for all object in a database

Mark C. Stock wrote:

> "Derek Smigelski" <derek.smigelski_at_bestsoftware.com> wrote in message
> news:820e9de3.0409030640.69a058d5_at_posting.google.com...
> | Hi all,
> |
> | I need a query that will simply return all Oracle role/permissions for
> | all object in a database. (IE do they have SELECT, UPDATE, DELETE etc
> | etc permissions.
> |
> | Thanks,
> | Derek Smigelski
>
>
> look at dba_tab_privs
>
> ++ mcs

Understanding that if someone also has, for example, SELECT ANY TABLE
there will be no related records in DBA_TAB_PRIVS.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)