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:
- In Object Explorer, expand the server, expand the Databases folder, expand SophosSecurity, expand Security, and then expand Schemas.
- Right-click Reports and click Properties.
- 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.
- For each user, in the Permissions for <user> section, on the Explicit tab, select Select under Grant, and then click OK.