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.
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
The password for the database user.
A list of Dynamic Data Masking symbols or variables. When you open the Security Rule Set Simulator, the
column lists the default global symbols. You can enter a value for the symbol in the
column, or you can choose not to define the symbol. If you want to add additional symbols, click the plus (+) icon below the
To run the simulator as a database user that is different from the database user that you entered in the
fields, define a value for the AUTH_USERNAME symbol. For example, you might enter a non-privileged user name in the AUTH_USERNAME
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.
The SQL statement that you want to run in the simulator.
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
at the bottom of the Security Rule Set Simulator.
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.
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
before you run the simulator.
Opens a dialog box that you use to import a saved simulator file into the Security Rule Set Simulator.
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.
Clears the simulator configuration and log output.
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: