Skip to main content

Dedicated report database user and schema

The optional Analytics app requires a dedicated report database user and schema.

When using the Bravura Security Fabric setup installer, you enter SSRS settings and:

  • Allow setup to create the user for you;

    Or

  • Use the following instructions to pre-configure the user and schema.

If you choose to pre-configure the report user and schema:

  1. Start Microsoft SQL Server Management Studio.

  2. Connect to the server as a system administrator (sysadmin role).

    You can do this using SQL Server authentication and the sa account, or using Windows authentication if the Windows user has the sysadmin role.

    For example, to connect to the server using the sa account, set:

    Server type: Database Engine

    Server name: <host name or IP address> \ <instance>

    Authentication: SQL authentication

    Login: sa

    Password <password for sa>

    Click Connect.

  3. Create a new schema in the database:

    1. In the Object Explorer pane expand Databases > <instancedatabase> > Security.

    2. Right-click Schemas, then click New Schema….

    3. Type the Schema name.

    4. Set the Schema owner to dbo.

      5537.png

    5. Click OK.

  4. Create a new login:

    1. In the Object Explorer pane, expand Security.

    2. Right-click Logins, then click New Login….

    3. On the General page, type the Login name.

    4. Select SQL Server Authentication.

    5. Type and confirm the password for the new login.

    6. Deselect the User must change password at next login and Enforce password expiration checkboxes.

    7. Set Default database to the instance database created either in a previous install or in Step 3.

      5538.png

    8. Click User Mapping on the left.

    9. Map the <instance database> to this new user and set the default schema to the schema created in the previous step.

      5539.png

    10. Click OK.

  5. Set the user in the database:

    1. In the Object Explorer pane, expand Databases > <instancedatabase> > Security > Users.

    2. Right-click the user created in Step 4 and click Properties.

    3. Click General on the left.

    4. Set the Default schema to the schema you created in Step 3.

      5540.png

    5. In the Membership area, enable:

      • db_datareader

      5541.png

    6. Click Securables on the left.

    7. Search and select Schema object types.

      5542.png

    8. Select the instance database's schema.

    9. Deny this user access to the instance database's schema.

      5543.png

    10. Search and select the report schema you created in Step 3.

    11. Grant Execute and Select permissions.

      5544.png

    12. Click OK.

In this section: