View all users and roles for a database
- Last UpdatedMar 06, 2025
- 1 minute read
To view all users and roles:
-
In SQL Server Management Studio, expand the server group and then expand the SQL Server associated with the AVEVA Historian.
-
Expand Databases, expand the database for which you want to view all users and roles; for example, the Runtime database, then expand Security.

-
To view all users, click Users. All users appear in the details pane.
-
To view all roles, click Roles. All roles appear in the details pane.