Create Sybase Login

A login defines a name and a password for a user to allow access to Adaptive Server. We can create login using command create login or stored procedure sp_addlogin. sp_addlogin is deprecated in 15.7 or later versions.

What happens when we execute create login in ASE?

1. Adaptive Server adds a row to master.dbo.syslogins
2. Assigns a unique system user ID (suid) for the new user, and fills in specified attribute information.
3. When a user logs in, Adaptive Server looks in syslogins for the name and password provided by the user.
4. The password column is encrypted with a one-way algorithm so it is not readable.

Syntax to Sybase login:

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

Parameters:
login profile
suid
login script
fullname
password expiration
min password length
max failed attempts
default database
default language

Examples:

create login george with password george321
go

sp_displaylogin george
go

select * from syslogings where fullname like 'george'
go