Video Screencast Help

What is the purpose of the Vontu\Protect\tools\sql SQL scripts

Created: 11 Mar 2012 • Updated: 12 Mar 2012 | 3 comments
Language Translations
yang_zhang's picture
+4 4 Votes
Login to vote

There are five SQL scripts under the folder \Vontu\Protect\tools\sql. These five SQL scripts are used for some kind of auditing purposes.

ClearAdminLockout.sql - Used to unlock DLP Administrator account. The DLP Administrator account will be locked due to multiple failed login attempts.

ClearSystemEvents.sql - This script will clear all records from the systemevents table. Systemevents table is used as a log by DLP to record system events for troubleshooting. There is no ongoing provision for periodically clearing out this table. It will grow and grow and grow.

ListAccountUserAction.sql - Audit report for user account changes.

ListUnsuccessfulLoginAttempts.sql - Audit report of failed login attempts.

ListUserSessions.sql - Audit report of user sessions.

Article Filed Under:

Comments 3 CommentsJump to latest comment

kishorilalWipro's picture

Hi yang,

This is very short and informative article. 

Thanks for sharing

Login to vote
seswho's picture

Thank you for the information, only one question. Where and how do I run these scripts?

You will never know the blessings you lose from “shooting the messenger”, instead of listening to or reading the message that was sent.

Login to vote
yang_zhang's picture

You can run these sql inside sqlplus after you log into the Oracle DB.

If a forum post solves your problem, please flag it as a solution. If you like an article, blog post or download vote it up.
Login to vote