Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Print Bookmark Alert me when this article is updated


HOW TO: Create logger in DDM to log user actions
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.
  4. Create a new rule in the security rule to log the information. 

    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>'​
Applies To
Product: Dynamic Data Masking
Problem Type: Configuration
User Type: Administrator
Project Phase: Configure
Product Version:
Database: Oracle
Operating System:
Other Software:
Last Modified Date:6/30/2020 11:37 PMID:596529
People who viewed this also viewed


Did this KB document help you?

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