Set object permissions

Object permissions control the actions that a user can perform on database objects, such as tables, indexes, views, defaults, triggers, rules, and procedures. You must be the owner (creator) of an object to grant and revoke permissions. You can grant object permissions by user and role, and by object.

To grant object permissions by object

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 expand the database to which you want to add the object permission. For example, expand the Runtime database.

3. Right-click the object and then click Properties. The Properties dialog box appears.

4. Click Permissions. The Permissions dialog box appears.

   

5. For each user or role, select permissions to grant for the object.

6. Click OK.

To grant object permissions by user or database role

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

8. Expand Databases and then expand the database to which you want to add the object permission. For example, expand the Runtime database.

9. Click Security.

10. Click either Users or Roles.

11. If you are selecting a role, click Database Roles or Application Roles.

12. Right-click the user or role and then click Properties. The Properties dialog box for the user or role appears.

13. Click Securables. The Securables page appears.

    

14. Select the object for which you want to grant permissions, and then select the permissions to grant listed in the Explicit tab.

15. Click OK.