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.

Report message to a moderator

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

Report message to a moderator

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: 21807
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.

Report message to a moderator

Previous Topic: Two password for one user
Next Topic: Hide SQL Statements
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 00:16:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.