Home » RDBMS Server » Security » Tracking All users SQL stmts as SYS and SYSTEM user
Tracking All users SQL stmts as SYS and SYSTEM user [message #171741] Thu, 11 May 2006 05:43 Go to next message
frank.svs
Messages: 162
Registered: February 2006
Senior Member
Hi Team,

I have a small doubt.
Can i track all the SQL statements sent by every user as SYS or SYSTEM USER.
If so what could be SQL Query.

I want know.

Thanks in Advance.
Re: Tracking All users SQL stmts as SYS and SYSTEM user [message #175976 is a reply to message #171741] Tue, 06 June 2006 04:39 Go to previous messageGo to next message
kamal480
Messages: 5
Registered: June 2006
Location: UAE
Junior Member

i think yes , by creating database triggers at each schema level.


try it
Re: Tracking All users SQL stmts as SYS and SYSTEM user [message #175978 is a reply to message #175976] Tue, 06 June 2006 04:42 Go to previous message
Littlefoot
Messages: 21690
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You might get lost if you start creating triggers all around. Oracle offers Auditing which is designed for this purpose; enable it and use its possibilities.
Previous Topic: Two password for one user
Next Topic: Hide SQL Statements
Goto Forum:
  


Current Time: Thu Dec 02 16:03:40 CST 2021