Set Database User Role

Top Previous Next

Four roles (types or levels of access) are provided for database users:

•	Full read/write. The user can read or modify all data in the database.

•	Full read. The user can read, but not modify, all data in the database.

•	Limited read. The user can read a limited set of data in the database, mostly though database views.

•	None (default). The user cannot read or modify data in the database.

Note that the role for each user needs to be set for each database. When a user is added or a new database is created the default role is None (no access). The role can be changed at any time.

Note: The roles are stored within the database, therefore if you backup a database the roles for the users are also backed up. If you later restore the database the roles for the users will be restored and set to those current at the time of the backup. After a restore you should review the roles in the database assigned to each user to ensure that they are still appropriate.

HOW-TO

Set the Roles for a Database User

1.	Start the Server Manager and select the Database Users tab.

2.	Review the list of existing users and select the user to set the roles of.

3.	Select the database to set the role for from the databases list.

4.	Click the Set Role list and select the appropriate role. The change takes effect immediately.