Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: alter/cfreate/drop user privileges

Re: alter/cfreate/drop user privileges

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 19 Dec 2004 13:34:18 -0800
Message-ID: <41c5f2ed$1_3@127.0.0.1>


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 =-----
Received on Sun Dec 19 2004 - 15:34:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US