Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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.

Comments 3 CommentsJump to latest comment

kishorilal1986's picture

Hi yang,

This is very short and informative article. 

Thanks for sharing

0
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.

0
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.
0
Login to vote