Database Monitoring Using Access Control

Create a database monitoring permissions using Access Control:

  1. On the home page of the console, click Access Control.

  2. In the Access Control pane, create resource pool for database users by clicking Create.

    1. In the General page enter the name, description and select the Database type for which you want to create the resource pool. Example: Microsoft SQL.

    2. Click Next

    3. Click +Add to select Microsoft SQL database. The resources are populated from the resources configured in the Credential Vault. If you have not done configure it at this point to view and select the appropriate resources.

    4. Click Create. You can view the newly created resource pool using Access Control > Resource Pools.

  3. Create user role of database users for database monitoring.

    1. To create this role, go to Access Control > User Roles > Create > General – specify the fields name and description. Click Next.

    2. In the Included Members page, click Add and select Database users. Click Add to select the users you want to add.

  4. Create an assignment.

    1. To configure the assignment, select the Access Control > Assignment, click Create Assignment.

    2. From the Resource Pools page, select the database you want to create the assignment for. Example: My SQL.

    3. Click Select.

    4. Select the User Role. Example: DB Users.

    5. Add a Description.

    6. Add Permissions. Example: My SQL Database Access and set the following fields

      • Time Restrictions: All Days (24 hours), Specify time range starting and ending. If you want custom setting use custom days.

      • Access and Monitoring Options page: Move the slider to the right if you want to disable Session Capture, by default this option is set to enable.

      • Customization page: add the customized scripts.

    7. Click Finish.

  5. You are redirected to the Assignments page, Click Create. Assignment created successfully message is displayed.

For more information about creating Resource Pools, User Roles, and Assignments, see Section 6.2, Access Control.