Manage users and roles using SQL Server Management Studio

To make managing a large number of database users easier, each username can be assigned to a Microsoft SQL Server role. All members of a role inherit the permissions that are assigned to that role. For example, if the user "MaryH" is added to the "aaPowerUsers" role, that user is automatically granted the permissions for that role. If a role name is not specified, the user is added only to the public role, which includes all users. There are two types of roles: server roles and database roles.

Using SQL Server Management Studio, you can assign Windows users and user groups, as well as Microsoft SQL Server users and roles, to roles.

You can also use the AVEVA Historian Security configurator to manage users and role assignments all at once from a simple interface. For more information, see Manage users and roles using the configurator.

For more information about default AVEVA Historian users and roles, see About security.