Set up permissions on the Database Server

1. Using SQL Management Studio, navigate to the Database Server ‣ Security ‣ Logins.
2. Add the NEXUS Users Active Directory group as a new Login.
3. Under Server Roles for the NEXUS Users Active Directory group Login, ensure “public” is checked.
4. Under Securables for the NEXUS Users Active Directory group Login, ensure the Grant permission for “View server state” is checked. This is required for the logged in user to query the active logins to display in the status bar, in addition to determining forced log-offs for Audit Log sessions.
5. Also under Securables is the permission “Administer bulk operations”. Ensure this permission is checked to grant bulk updates during import on some tables.

Set up permissions on the NEXUS database

1. Using SQL Management Studio, navigate to the NEXUS database.
2. Add NEXUS Users Active Directory group to the “public” Database Role.
3. Add NEXUS Users Active Directory group to the “db_owner” Database Role.