Each user must be authorized for the SQL Server instance (displayed in SSMS in the Security/Logins tree for the server). If the user should be permitted to create new databases within EZLease, give the server role dbcreator.
Next, the user is authorized to use EZLease. This can be accomplished in one of two ways:
Using SQL Server Management Studio
If you are using the Multicompany option, all users should have the db_datawriter role for EZ_ANGroup. EZLease manages which users can update individual companies’ settings, but the db_datawriter role is required to properly log when companies are loaded because their database(s) are used.
|
Step |
Action |
|
1 |
Add the user to the Security/Users tree for EZ_ANGroup. |
|
2 |
Right-click the user’s name and choose Properties. |
|
3 |
Select the Membership page. |
|
4 |
Assign the following roles as desired:
|
Using EZLease
You must be logged in to EZLease as a user with either the db_securityadmin or db_owner role.
|
Step |
Action |
|
1 |
File / System Options / Account Numbering / Set SQL Permissions. |
|
2 |
Enter the user’s login name in the blank box (you must type it correctly; it is not possible for security reasons to provide a list of eligible login names). |
|
3 |
Read permission is automatically enabled. For write permission (make changes to account number groups and other lists in System Options), check the box. |