If you are the owner 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 SQL Server Management Studio or a similar management application; in technical language, your user needs the db_owner permission.
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, use SQL Server Management Studio or another management tool; this requires the appropriate permissions for the entire server.)
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. If you use SQL Server Management Studio to give a user write permission, be sure to give them the db_datawriter role for consistency with EZLease’s permission checking process.
No changes are implemented until you click OK.
See also
SQL Server usage