Re: need to list all user permissions

From: Jared Still <jkstill_at_cybcon.com>
Date: Sun, 07 Nov 2004 11:17:40 -0800
Message-Id: <pan.2004.11.07.19.17.40.890699@cybcon.com>

On Sat, 06 Nov 2004 06:41:35 +0000, 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.

see http://www.petefinnigan.com/find_all_privs.sql

Jared Received on Sun Nov 07 2004 - 13:17:40 CST