Re: need to list all user permissions

"Beldar Conehead" <beldarconehead_at_earthlink.net> a écrit dans le message de news:zm_id.5123$Gm6.1031_at_newsread3.news.atl.earthlink.net...
> 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.
>
>

You'll a script at:

http://www.dba-village.com/dba/village/dvp_scripts.ScriptDetails?ScrId=1211

Before you have to register at:
http://www.dba-village.com/dba/village/dvp_base.main but it is free and spam safe.

-- 
Regards
Michel Cadot