Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: need to list all user permissions
Beldar Conehead wrote:
> I've been asked for a cross-matrix of users and their permissions.
>
> That is, for each user in the database I need to find the permissions he/she
> has against every table in the database. It makes no difference if
> permission has been granted explicitly, or thru a role, or thru a system
> privilege. Any body know of an existing script? Is there any combination
> of sys-owned tables (e.g. the $ tables) that would help me?
>
> Thanx.
>
>
Take a look at the dbms_metadata package in the documentation. You can
extract the ddl for the grants and filter as needed.
Received on Sat Nov 06 2004 - 11:16:30 CST