Re: Script to show all user privileges in a db

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 13 Dec 2007 12:52:33 -0800 (PST)
Message-ID: <50376132-4bd2-47cb-a61f-bbd5a3ccc566@d21g2000prf.googlegroups.com>

On Dec 13, 1:36 pm, Massa Batheli <mng..._at_gmail.com> wrote:
> Does anyone have a script that can list all database users and thier
> privileges
> Do not want to try to reinvent the wheel if some one out there has
> already done that
>
> Appreciate your help on this
>
> Massa

Look at the following:

How do I find out which users have the rights, or privileges, to access a given object ? http://www.jlcomp.demon.co.uk/faq/privileges.html

There are system privileges, object priviges, roles, and privileges inherited via roles. Depending on the desired output format more than one query is likely to be desired.

HTH -- Mark D Powell -- Received on Thu Dec 13 2007 - 14:52:33 CST