DBA_SYS_PRIVS lists system privileges granted to users and roles. This view
does not display the USERNAME column.
USER_SYS_PRIVS lists system privileges granted to the current user. This
view does not display the GRANTEE column, but instead displays the USERNAME
column.
DBA_TAB_PRIVS lists all grants on all objects in the database. This view
does not display the TABLE_SCHEMA column.
USER_TAB_PRIVS lists grants on all objects where the current user is the
grantee. This view does not display the TABLE_SCHEMA column.
Deepa Kale -DBA
Jyoti Structures - Nasik(IT)



[Email Address Removed]
.com To: "LazyDBA.com Discussion" <[Email Address Removed]
cc:
01/29/2004 11:08 Subject: user privileges
PM
Please respond to
schuster






Hi All,

Does anyone have a script that they would be willing to share -

I'd like to be able list out all users and all of their privileges,
regardless of whether those privileges were granted directly or through a
role. I thought that I had a pl/sql script that did this, but I can't seem
to find it.....

Thanks!




--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these terms:
http://www.lazydba.com/legal.html






Oracle LazyDBA home page