Home » RDBMS Server » Security » Shutdown database only (Oracle 10g)
Shutdown database only [message #383443] Wed, 28 January 2009 22:50 Go to next message
Messages: 48
Registered: June 2007
Location: Bangladesh

I want to create a user who can only STARTUP and SHUTDOWN the database as well as rman backup.
I know about SYSOPER, but this gives the user ALTER DATABASE ARCHIVELOG as well.

What should I do?
Re: Shutdown database only [message #383513 is a reply to message #383443] Thu, 29 January 2009 00:55 Go to previous message
Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing but maybe use Database Vault or use a complex database trigger (which may not work with ALTER DATABASE I didn't try).


[Updated on: Thu, 29 January 2009 00:56]

Report message to a moderator

Previous Topic: my I know your opinion about application user ?
Next Topic: Account athenticate to the database
Goto Forum:

Current Time: Sat Apr 01 18:36:48 CDT 2023