Grant access to the audit data using SQL Server Management Studio

Before you can grant "Select" permission on the schema Reports in the database SophosSecurity to a user in SQL Server Management Studio, ensure that the user has a SQL Server login and is a SophosSecurity database user.

  • If the user already has a SQL Server login, add it as a SophosSecurity database user. In Object Explorer, expand the server, expand the Databases folder, expand SophosSecurity, and then expand Security. Right-click Users and click New User. In the Database User dialog box, enter the user name and select the login name. Click OK.

    For more information about creating database users, go to SQL: Create a user with SSMS.

  • If the user doesn't have a SQL Server login, add a new SQL Server login and make it a SophosSecurity database user. In Object Explorer, expand the server, expand Security. Right-click Logins and click New Login. In the Login dialog box, on the General page, enter the account or group name. Go to the User Mapping page and select SophosSecurity. Click OK.

    For more information about creating SQL Server logins, see SQL: Create a login using SSMS.

To grant access to the audit data to a user, in SQL Server Management Studio:

  1. In Object Explorer, expand the server, expand the Databases folder, expand SophosSecurity, expand Security, and then expand Schemas.
  2. Right-click Reports and click Properties.
  3. In the Schema Properties - Reports dialog box, on the Permissions page, click Search. In the Select Users or Roles dialog box, add a user or users.
  4. For each user, in the Permissions for <user> section, on the Explicit tab, select Select under Grant, and then click OK.