Home » RDBMS Server » Security » User security violations (Oracle, 10.2.0.2.0 , unix)
User security violations [message #467778] Tue, 27 July 2010 05:30 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member


Hi,

Can anybody provide me the script which would track all the users security violations like ... say for example i want to find which users logged in and what he did in database prospective.


Thanks
Re: User security violations [message #467780 is a reply to message #467778] Tue, 27 July 2010 05:37 Go to previous message
Michel Cadot
Messages: 67546
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
AUDIT and then query DBA_AUDIT_TRAIL.

Regards
Michel
Previous Topic: ORA-01031:insufficient privileges,I already checked the other threads about this, still doesn't work
Next Topic: Logon/off audit using Audit_Trail
Goto Forum:
  


Current Time: Sun Nov 29 20:16:52 CST 2020