After adding the appropriate database connector, you must add rules to provide access to the database. You can add the database rule manually or by using the policy template.
On the home page of the administration console, click Command Control.
To add a rule and provide the access to supported databases, perform the following:
(Conditional) To add the rules automatically using policy template, perform the following:
In the Command control pane, click Rules.
In the details pane, click Add Policy Template and then select the required policy from the drop-down list. For example, select Oracle DB Session to add rules for Oracle database.
Click Import.
When you click import a new rule is added and based on the type of policy selected, the appropriate command is also added to the rule. You can further edit the rule as required.
(Conditional) To add the rules manually, perform the following:
In the Command control pane, click Rules.
In the details pane, click Add.
Specify a name for the database rule, then click Add.
To configure the rule, select the rule, click edit icon in the details pane.
Configure only the following:
Session Capture: Select On to capture the activities done by the user.
Authorize: Select Yes, then select Stop from the drop-down list.
Click Modify.
The settings that are defined for the rule are displayed in the console.
In the middle pane, click the Commands icon.
From the list of commands, drag the required database command and drop it to the database rule.
NOTE:In case the user needs to have restricted access for specific instances of Microsoft SQL Server, you can create custom commands and drag it to the database rule. For example, if you want to provide restricted access to user for one of the two instances, then you need to add <DBMSSQLAccess> InstanceName1 under Commands field when creating the custom command.