There are two levels of permissions for EZLease. The first gives a user permission to use EZLease as a whole, and make changes to the account number groups database, any lists of permitted entries to user- defined fields, and other system settings. Users are set up for this level of access from System Options, Account Numbering, Set SQL Permissions. See SQL - Add & Authorize Users for more. You must be defined as the owner (db_owner role) or security administrator (db_securityadmin role) of the SQL account number groups database (EZ_ANGroup) to view or change these permissions.
If you do not have sysadmin or an equivalent role on the server, to add new users to the account number groups database, the server administrator needs to give the command (in SQL Server Management Studio).
GRANT VIEW ANY DEFINITION TO yourusername This enables you to see what other users are on the server.
The second level of permissions is for an individual database. If you are the owner or security administrator of a database, you may add and remove other users, specifying whether they have read-only or read and write access. This is accomplished from the File menu, SQL Database Permissions. This menu option is only enabled when a SQL database is open and you are its owner (or have equivalent permissions on the server). Note that it is possible to set individual SQL Server permissions in an unexpected way such that EZLease does not recognize that you are authorized to change other users’ permissions. If this menu option is not available and you do have owner permissions, you should alter permissions using SSMS or a similar management application; in technical language, your user needs the db_owner or db_securityadmin role.
The current list of permitted users for the database is listed, as well as whether they have read and write permission. A user without at least read permission is not listed.
You may add new users by entering the new name in the blank user box. A new user is always given read permission. To give write permission, check the box. Any users you wish to add must already be created on this instance of SQL Server. (If you need to set up a new user on the server, see Authorizing Users earlier in this chapter.)
To copy all the users and permissions set for EZLease as a whole to a particular database, click on the Load All button.
To delete an existing user, click on the tan box at the left of the line to highlight the user’s line, then press the Delete key.
To change whether or not a user has write permission, check or uncheck the Write box. No changes are implemented until you click OK.
Users may also be authorized, or their permissions changed, using SSMS:
|
Step |
Action |
|
1 |
Add the user to the Security/Users tree for the database |
|
2 |
Right-click the user’s name and choose Properties. |
|
3 |
Select the Membership page. |
|
4 |
Assign the following roles as desired:
|
This permissions window does not apply to Access databases; permissions for Access databases are defined by Windows using the Security tab of the Properties for the file or folder (reached by right-clicking on the file or folder name in Windows Explorer/My Computer).