Create a Replication Server Login Name

Use the create user command to add new user login names to Replication Server.

All users have permission to execute all admin commands.

You must specify a password for the user when the login name is created. If the user has no password, you must set the password to “null,” which specifies an empty string.

The create user command requires sa permission. The syntax for create user is:

create user user
set password {passwd | null}

A user’s password can be up to 30 characters long and include letters, digits, and symbols. Case is significant. If the password contains spaces, enclose the password in single quotation marks.

Users can change their own passwords using the alter user command.

The following example creates a login name for the user “thomk” with the password “vacUUm”:

create user thomk
 set password vacUUm