Re: alter/cfreate/drop user privileges

<premmehrotra_at_hotmail.com> a écrit dans le message de news:1103254605.352636.188600_at_z14g2000cwz.googlegroups.com...
| I am on Oracle9i on HP UNIX 11i.
|
| I have a database user created for managing database users
| in the database. It has minimum sets of privileges such as alter.
| create and drop privileges. Is there anyway to restrict this user to
| make any
| modififications to accounts which have dba privileges. For example.
| this account should not be able to alter passwords for sys, system or
| drop them.
|
| Prem
|
|
| Prem
|

You can use a DDL database trigger:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c18trigs.htm#10004 http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_76a.htm#2063897

Regards
Michel Cadot Received on Fri Dec 17 2004 - 01:23:11 CST