Re: alter/cfreate/drop user privileges

premmehrotra_at_hotmail.com wrote:

> 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

Look at ON DATABASE triggers. For some examples: go to http://www.psoug.org
click on Morgan's Library
click on DDL Triggers

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
   http://www.newsfeed.com       The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----