Create a Replication Server Login Name

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

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 {new_password | null} 
[set password_parameter to 'parameter_value']

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.

To create a login name for the user “thomk” with the password “vacUUm”, enter:

create user thomk
 set password vacUUm

As the administrator, you can set a password expiration interval for a user. For example, to create a user named jsmith having an initial password of 1Buiopr89, with a password expiration interval of 90 days, enter:

create user jsmith
set password to 1Buiopr89
set password_expiration to '90'

See Replication Server Reference Manual > Replication Server Commands > create user.