Use the SET USER command to create users, change the password for a user, or run R:BASE with a user identifier and password, if one has been set up.
Options
FOR userid
Specifies a user identifier. For a value with spaces, the userid must be enclosed in quotes.
owner
Specifies the database owner name.
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. For a value with spaces, the userid must be enclosed in quotes.
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 a user identifier. User identifiers have a maximum length of 36 characters. Passwords have a minimum length of three characters and maximum length of 36 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.
