USER
Top  Previous  Next

Use the SET USER command to run R:BASE with a user identifier and password, if one has been set up.

setuser

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.