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

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: 68624
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).

Regards
Michel

[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: Thu Mar 28 09:25:56 CDT 2024