Home » RDBMS Server » Server Administration » log 'alter system' command (oracle database 10.2.4.0 Solaris)
log 'alter system' command [message #378268] Mon, 29 December 2008 11:22 Go to next message
Orna
Messages: 62
Registered: November 2008
Member
Hi

I am looking for a way to track alter system / alter database commands.

Database triggers are not logging them : I do have a database trigger for DDLs tracking that works great but alter system commands are not captured by it . also trigger 'alter alter on database ' - do not log alter system or alter database

Is there a way for me to force a command to appear in the alert log ?

Or any other way you can think of ?

thanks
Orna
Re: log 'alter system' command [message #378272 is a reply to message #378268] Mon, 29 December 2008 12:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't log those that are currently not logged.

Regards
Michel
Re: log 'alter system' command [message #378275 is a reply to message #378272] Mon, 29 December 2008 13:17 Go to previous messageGo to next message
Orna
Messages: 62
Registered: November 2008
Member
Can't I force logging of a certain command into the alert log,even if its not currently logged.

let's say I want each 'alter system flush shared_pool' to be logged.
Is it possible ?
Re: log 'alter system' command [message #378277 is a reply to message #378275] Mon, 29 December 2008 13:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Re: log 'alter system' command [message #378285 is a reply to message #378277] Mon, 29 December 2008 15:25 Go to previous messageGo to next message
Orna
Messages: 62
Registered: November 2008
Member
Sad

Thanks
Orna
Re: log 'alter system' command [message #378338 is a reply to message #378285] Tue, 30 December 2008 01:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If it is really important for you, you can grant no one direct access to alter system command, create a procedure to do this and grant execute on procedure to allowed user.
In this procedure you can do what you xant.

By the way, you can activate audit on "alter system".
The option depends on your final need.

Regards
Michel
Re: log 'alter system' command [message #378450 is a reply to message #378338] Tue, 30 December 2008 08:23 Go to previous message
Orna
Messages: 62
Registered: November 2008
Member
No, its not that I do not want to give my DBA the privilege, I just want to have a way to track it.

Since I already have my customize trigger that logs all the DDLs in the system, I was hoping to complete the picture by monitoring also alter system commands.

I will look at the audit option - thanks

orna
Previous Topic: OEM problem with wrong date_time
Next Topic: client 9i for sparc 64 bit
Goto Forum:
  


Current Time: Fri Dec 09 12:05:05 CST 2016

Total time taken to generate the page: 0.13368 seconds