If a login profile is not specified when creating a login account, the default login profile is associated with the new account. If a default login does not exist, Adaptive Server applies password policy attributes specified by sp_passwordpolicy or default attributes. See Applying login profile and password policy attributes for information about the order in which attributes are applied.
The following example creates the login account omar_khayyam with password rubaiyat and associates the account with the login profile emp_lp:
create login omar_khayyam with password rubaiyat login profile emp_lp
The following example modifies the login account omar_khayyam and associates the account with the login profile staff_lp:
alter login omar_khayyam modify login profile staff_lp
