User Database Access

With the User Database Access function, you can control which database(s) a specific user can access and use. You would only use this function if a user should have access to only certain databases; otherwise a user automatically has access to all databases as long as the Allow Database Change check box is selected in Maintain Users for the user name.

Upon accessing this function, select the User you want from the User Code list.

Two informational lines display above the database list:

The user's current Database Change permission status (whether the Allow Database Change check box is selected for this user in Maintain Users).
The user's Default Database. The user will maintain access to this database regardless of the settings below.

Data Field Information

Prompt	Response	Req	Len
User Code	Select the user from the User Code list. This field is information only after selection and reflects the User Code that you selected.	Y	10
Allow Database	Select the check boxes next to each database number that you want the selected user to have access to. Select the Default Database Only check box to grant the user access only to their Default Database. When selected, the individual database check boxes below are not used.		80

For information on how to change databases, see Desktop Basics. If the user tries to access a database that they do not have access to use, a message displays stating, 'Your user code does not permit change to this database.'

NOTE: This restriction check does not occur when the user signs on. It only occurs when the user attempts to change databases. Therefore, when the user logs in, it automatically signs on to the database stored in the Database Number field in Maintain Users for their user name.