Managing login profiles

System security officers can define, alter, and drop login profiles.

Table 3-1 summarizes the system procedures and commands used to create and manage login profiles.

**Table 3-4: Managing login profiles in Adaptive Server**
Task	Required role	Command or procedure	Database
Create login profiles	System security officer	create login profile	Master database
Alter login profiles	System security officer	alter login profile	Master database
Drop login profiles	System security officer	drop login profile	Master database
Return login profile ID	System security officer	lprofile_id	Any database
Return login profile name	System security officer	lprofile_name	Any database
Display the name login profiles	System security officer	sp_displaylogin	Any database
Displays information about login profiles	System security officer	sp_securityprofile	Any database