Users Menu Options
This page describes the menu options available above the Users list when managing user accounts. These options provide bulk operations and administrative actions that go beyond editing individual user records.
Prerequisites
You must have Administrator or Configuration user group permissions to use these options.
Available Menu Options
The Users menu above the list of users provides the following operations:
| Menu Option | Description | When to Use |
|---|---|---|
| Create a new user | Opens the User Editor dialog to create a new user account. | When onboarding a new employee or setting up a service account. |
| Edit a selected user | Opens the User Editor for the selected user. | To change a user's group, profile, or other settings. |
| Enable a selected user | Re-enables a previously disabled user account. | When a user returns from leave or their access is restored. |
| Disable a selected user | Prevents the user from logging in without deleting their account. | When a user is on leave, under investigation, or temporarily not authorised. |
| Delete a user | Marks the user account as deleted. The record remains in the database for audit purposes. | When a user has permanently left the organisation. |
| Reset a User's Permissions | Re-applies the user's database permissions based on their user group. | If a user is experiencing unexpected access problems, or after restoring the database from a backup. Permission records in the database can become out of sync with user group settings -- this option forces them back into alignment. |
| Log off the selected users | Terminates the active sessions for the selected users. | When you need to force a user off the system (e.g., before maintenance, or if their session is stuck). |
| Unlock Users | Unlocks a user account that SQL Server has locked due to too many failed login attempts. | When a user reports they cannot log in and you suspect their account has been locked by the database due to incorrect password attempts. |
Common Procedures
Resetting Permissions After a Database Restore
After restoring a database from backup, user permissions may be out of sync because the backup may contain different permission records than the current database:
- Navigate to Admin > Users.
- Select all affected users (or select each one individually).
- From the Users menu, choose Reset a User's Permissions.
- The system will re-apply the correct permissions based on each user's current user group.
Unlocking a Locked-Out User
When SQL Server locks a user account after repeated failed login attempts:
- Navigate to Admin > Users.
- Select the locked user.
- From the Users menu, choose Unlock Users.
- The user can now attempt to log in again with the correct password.
Tip: If a user is repeatedly getting locked out, check whether they have saved an old password in their browser, a scheduled script, or a mobile device that is sending incorrect credentials automatically.
Force Logging Off Users Before Maintenance
Before performing database maintenance or upgrades:
- Navigate to Admin > Users.
- Select all currently logged-in users.
- From the Users menu, choose Log off the selected users.
- Users will see a session-expired message on their next action and will need to log in again after maintenance is complete.
Related Articles
- Users — creating and editing user accounts
- User Groups — the permissions that are applied when resetting
- User Logon History — reviewing login activity