Re: ORacle user

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 24 Jan 2005 08:04:17 -0800
Message-ID: <116582657.0000bcb2.004@drn.newsguy.com>

In article <1106581267.570664.238820_at_z14g2000cwz.googlegroups.com>, DMina_at_laiki.com says...
>
>Hello,
>
>Can I create an ORACLE user who will only have priviledge to shutdown
>or startup a database?
>
>Thanks
>

That is what the SYSOPER (as opposed to SYSDBA) role is all about. It has a little more than shutdown/startup (things you need to startup and shutdown)

http://download-west.oracle.com/docs/cd/B10501_01/win.920/a95490/glossary.htm#432535

They will have "public" privileges and the ability to shutdown/startup.

see
http://otn.oracle.com/pls/db92/db92.drilldown?remark=&word=sysoper&book=&preference=&vbook=1

-- 
Thomas Kyte
Oracle Public Sector
http://asktom.oracle.com/
opinions are my own and may not reflect those of Oracle Corporation

Received on Mon Jan 24 2005 - 10:04:17 CST