Re: DB privilege management utility wanted

Steve Chell wrote:
>
> Hi all. I'm looking for recommendations for
> a utility that will facilitate the management
> of database system privileges, object privileges
> and roles.
>
> The utility needs to run in a Windows 3.1
> environment (although we *are* planning on
> upgrading to Win95 or NT in about 6 months),
> with an Oracle 7.1.6 server (running under
> Solaris). Ideally it would include the following
> features:
>
> 1. Privileges can be maintained on a per user,
> per role or per object basis. A list of
> all users, roles and objects (grouped by schema)
> in the database would be available.
>
> 2. On selecting a username, all system privileges,
> object privileges and roles that have been
> granted to that user would be displayed.
> These could be revoked or added to as required.
>
> 3. On selecting a role, all system privileges,
> object privileges and other roles that have
> been granted to that role would be displayed.
> These could be revoked or added to as required.
>
> 4. On selecting on object (eg a table), all
> privileges which have been granted on that
> object would be displayed, showing the grantee.
> Again, these could be revoked or atted to
> as required.
>
> Thank you for your advice.
>
> Steve Chell
> slc_at_stevensons.co.nz

Take a look at MORE Application Manager by MORE Systems, Inc. (617) 251-9217.

It does what you are looking for plus much more. Received on Fri Jul 19 1996 - 00:00:00 CEST