Re: user with administrative priviledges

fireball wrote:
> Uzytkownik <ivl5_at_hotmail.com> napisal w wiadomosci
>

>> I think it's a very good idea to replicate SYSTEM privileges in another
>> user and lock down SYS/SYSTEM.

CREATE ROLE mgmt_role;

GRANT <privilege_name> TO mgmt_role;

CREATE USER <user_name> ....;

GRANT mgmt_role TO <user_name>;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org