create login

Creates a login account; specifies a password, a login profile for the account, and user-supplied parameters to be assigned to the account.

Syntax

create login login_name with [encrypted] 
	password password 
	[attribute_value_pair_list]

Parameters

Examples

Usage

  • Precedence rules determine how login account attributes are applied when attributes are taken from different login profiles or when values have been specified using sp_passwordpolicy.

  • For ease of management, it is strongly recommended that all users’ SAP ASE login names be the same as their operating system login names. This makes it easier to correlate audit data between the operating system and the SAP ASE server. Otherwise, keep a record of the correspondence between operating system and server login names.

See also:
  • For more information about creating login accounts, see the Security Administration Guide. For precedence rules, see Applying login profile and password policy attributes in the Security Administration Guide.

  • lprofile_id, lprofile_name in Reference Manual: Building Blocks

  • sp_passwordpolicy, sp_displaylogin, sp_displayroles, sp_locklogin in Reference Manual: Procedures

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

The permission checks for create login differ based on your granular permissions settings.

SettingDescription
Enabled

With granular permissions enabled, you must be a user with the manage any login privilege.

Disabled

With granular permissions disabled, you must be a user with sso_role.

Auditing

Values in event and extrainfo columns of sysaudits are:

InformationValues
Event

103

Audit option

login_admin

Command or access audited

create login

Information in extrainfo

Keywords contain: WITH attribute_value_pair_list

Related reference
alter login
alter login profile
create login profile
drop login
drop login profile