Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking
  3. Rules
  4. Connection Rules
  5. Security Rules
  6. Security Rule Set Simulator
  7. Masking Functions
  8. Glossary

Security Rule Set Simulator Parameters

Security Rule Set Simulator Parameters

The Security Rule Set Simulator contains fields for database information, symbol definitions, an SQL statement, and log output.
The Security Rule Set Simulator contains the following parameters:
DDM Database Name
The name of the Dynamic Data Masking database that you defined in the Management Console. If you do not enter a database name, the simulator runs without a database.
DBA Username
The name of the database user that you want to use to connect to the database. The user should be a privileged user that has access to all the tables in the database. Generally it is the user that you used to connect to the database in the Management Console.
If you want to simulate the rule for a non-privileged user, enter login information for a privileged user and enter the non-privileged user name in the AUTH_USERNAME symbol in the
Symbol Definition
box.
DBA Password
The password for the database user.
Symbol Definition
A list of Dynamic Data Masking symbols or variables. When you open the Security Rule Set Simulator, the
Symbol Name
column lists the default global symbols. You can enter a value for the symbol in the
Symbol Value
column, or you can choose not to define the symbol. If you want to add additional symbols, click the plus (+) icon below the
Symbol Definition
box.
To run the simulator as a database user that is different from the database user that you entered in the
DBA Username
and
DBA Password
fields, define a value for the AUTH_USERNAME symbol. For example, you might enter a non-privileged user name in the AUTH_USERNAME
Symbol Value
field. The simulator runs the SQL statement as if the non-privileged user sent the request.
Symbols that you define in the Security Rule Set Simulator only exist within the simulator and do not affect the Dynamic Data Masking Server configuration.
SQL Statement
The SQL statement that you want to run in the simulator.
Log Output
The log output from the last simulation. Dynamic Data Masking does not save the Security Rule Set Simulator log output in the Dynamic Data Masking log files. To save the log output from the simulator, click
Save File
at the bottom of the Security Rule Set Simulator.
Debug Mode
Runs the simulator in debug mode and creates a detailed log output that displays information similar to the log output in the server.log file.
Run
Runs the simulator.
When you run the simulator, the simulator overwrites the log output from the previous simulation. If you want to save the log output from the previous simulation, click
Save File
before you run the simulator.
Open File
Opens a dialog box that you use to import a saved simulator file into the Security Rule Set Simulator.
Save File
Opens a dialog box that you use to save the save the simulator configuration and log output as an xml file. By default, the dialog box opens to the user root directory.
Clear
Clears the simulator configuration and log output.
Close
Closes the Security Rule Set Simulator. The Security Rule Set Simulator saves the simulator configuration and log output until you close the security rule set. When you close the rule set, the simulator resets.
The following image shows the Security Rule Set Simulator:
The Security Rule Set Simulator has fields for database information, symbol definitions, an SQL statement, and log output.