Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: query that will simply return all Oracle role/permissions for all object in a database

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

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sun, 5 Sep 2004 09:20:10 -0400
Message-ID: <7qudnSpoGIMMj6bcRVn-jA@comcast.com>

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1094255690.866056_at_yasure...
| 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)
|

in which case you will also need to look at DBA_SYS_PRIVS for users with various '%ANY TABLE' privs (and perhaps also the 'EXECUTE ANY%' privs)

(good catch daniel)

plus, if you're trying to determine what object privs particular users have, you'll also want to take a look at what roles they have, and they determine what privs whose roles confer to them -- so likely you'll also be looking at DBA_ROLE_PRIVS ++ mcs Received on Sun Sep 05 2004 - 08:20:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US