Use the SET USER command to run R:BASE with a user identifier and password, if one has been set up.
Options
FOR userid
Specifies a user identifier.
password
Creates a new password. Enter NONE to remove an existing password.
PASSWORD
Specifies or changes the password for the current user identifier.
TO password
Creates a new password. Enter NONE to remove an existing password.
userid
Specifies a user identifier.
About the SET USER Command
Passwords are specific to user identifiers and databases and are not required by R:BASE; however, once a password is set up, R:BASE prompts for the user's password every time the user connects to the database or issues his/her user identifier. User identifiers have a maximum length of 18 characters. Passwords have a minimum length of three characters and maximum length of 18 characters
To run R:BASE with your user identifier then connect to the database, enter the following command line:
SET USER <Userid>
You can also enter the following command line to run R:BASE with your user identifier:
SET USER
R:BASE displays a dialog box and prompts you for your user identifier.
When a password has been set up for a user identifier, R:BASE prompts for the password after the correct user identifier has been entered.
Note: When a user enters a user identifier or password in a dialog box, the user identifier is not displayed on screen.
To add or change a password, connect to the database with the user identifier and enter the following command line:
SET USER PASSWORD
R:BASE prompts for the user's identifier, then prompts for the password. A user can cancel a password by entering NONE.
If the database owner is the current user, the database owner can assign him/herself a password using the SET USER PASSWORD command; however, if the database owner forgets the assigned password, the password cannot be found or changed.
As the database owner, to change a user's password, connect to the database and enter the following command line:
SET USER PASSWORD FOR <Userid> TO <Password>
Enter your current password when R:BASE prompts you for it, then when R:BASE prompts you for a new password, enter NONE.
Note: A user's password is revoked when the database owner revokes all the user's privileges.