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

derek.smigelski_at_bestsoftware.com (Derek Smigelski) 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

Derek,

I have once written a script that recursively (that is also via roles) lists the object privileges. You find it on my homepage at:

http://www.adp-gmbh.ch/ora/misc/recursively_list_privilege.html

(Named Object Privileges)

hth

Rene

-- 
  Rene Nyffenegger
  www.adp-gmbh.ch