Set statement permissions

Statement permissions control who can issue particular Transact-SQL statements, such as SELECT, INSERT, or DELETE. You must be a member of the sysadmin or db_owner roles to grant and revoke statement permissions.

Note: CREATE DATABASE permissions can only be set from the primary database.

To set statement permissions

1. In SQL Server Management Studio, expand the server group and then expand the SQL Server associated with the AVEVA Historian.

2. Expand Databases and then right-click the database for which you want to set statement permissions. For example, right-click the Runtime database.

3. Click Properties. The Database Properties dialog box appears.

4. Click Permissions. The Permissions page appears.

   

5. Select the user or role to which you want to grant permissions, and then select the permissions to grant.

6. Click OK.