create user

Description

Adds a new user login name to a Replication Server.

Syntax

create user user
set password {passwd | null}

Parameters

user

The new user’s Replication Server login name. Login names must conform to the rules for identifiers.

passwd

The user’s password. It can be up to 30 characters long and can include letters, numerals, and symbols. Case is significant. If the password contains spaces, enclose the password in quotation marks. When you create or alter a user login name, you must specify a password or “null.” A null password lets a user log in without being prompted for a password.

Examples

Example 1

Creates a new user login name “louise” with the password “EnnuI”:

create user louise
 set password EnnuI

Usage

Permissions

create user requires “sa” permission.

See also

alter user, drop user, grant, revoke