alter/cfreate/drop user privileges

Giganews Newsgroups
Subject: alter/cfreate/drop user privileges
Posted by:  premmehrot…@hotmail.com
Date: 16 Dec 2004

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

Replies