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?

Report message to a moderator

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: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 23 20:31:46 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.