DB privilege management utility wanted
From: Steve Chell <slc_at_stevensons.co.nz>
Date: 1996/07/18
Message-ID: <4sjppi$67j_at_xbox.stevensons.co.nz>#1/1
Date: 1996/07/18
Message-ID: <4sjppi$67j_at_xbox.stevensons.co.nz>#1/1
Hi all. I'm looking for recommendations for a utility that will facilitate the management of database system privileges, object privileges and roles.
- 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.
- 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.
- 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.
- 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
Received on Thu Jul 18 1996 - 00:00:00 CEST