Add a new database user

To add a database user

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

2. Expand Databases, expand the database to which you want to add the new user, then expand Security.

3. Right-click Users and then click New Database User. The Database User Properties dialog box appears.

   

4. In the User name box, type the new user name.

5. In the Login name list, select the login ID to associate with the user name. You can also select <new> and then type a new login ID to be added to the system at the same time as the database user.

6. In the Default schema list, select the default schema for the user. This schema owns all the objects this user creates, unless a different schema is specified.

7. In the Owned Schemas window, check the owned schemas for this user. (Schemas can only be owned by a single user.)

8. In the Database role membership window, select the database role to make the user a member of.

   Note: All users are also included in the public role. Membership in this role is permanent and cannot be altered.

9. Click OK.