Creating a Replication Server login name

The create user command adds new user login names to Replication Server. All users have permission to execute all admin commands. See “Permission summary” for individual 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, which is described in the section “Changing a Replication Server password”.

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

create user thomk
 set password vacUUm