Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Create logger in DDM to log user actions
Solution
To create a logger to log the user activities to a log file, create a new logger and an appender.
  1. Right click the logger and click Add Logger.
  2. Provide any name for the logger:
    Add LoggerDDM.png 
  3. Right click the newly created Logger and Add Appender.
    AppenderDDM.png 
  4. Create a new rule in the security rule to log the information. 
    LoggerRule.png 

    Log :  '\(AUTH_USERNAME)' logged in to '\(AUTH_DATABASE_NAME)' DB from '\(CLIENT_IP)'​

    The above rule will write to the log file specified in the logger SQLAudit.

More Information
​Sample log entry
09/26 22:05:11,668 [DDM for Oracle-1] INFO  - Log :  '<LOGIN USER>' logged in to '<DB NAME>' DB from '<IP ADDRESS>'​
Reference
Applies To
Product: Dynamic Data Masking
Problem Type: Configuration
User Type: Administrator
Project Phase: Configure
Product Version:
Database: Oracle
Operating System:
Other Software:
Attachments
Last Modified Date:6/30/2020 11:37 PMID:596529
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)