A login defines a name and a password for a user to allow access to Adaptive Server. When you execute create login, Adaptive Server adds a row to master.dbo.syslogins, assigns a unique system user ID (suid) for the new user, and fills in specified attribute information. When a user logs in, Adaptive Server looks in syslogins for the name and password provided by the user. The password column is encrypted with a one-way algorithm so it is not readable.
A login profile is a collection of attributes to be applied to a set of login accounts. The attributes define login characteristics, such as default roles or the login script associated with each login bound to the profile. Login profiles save save time for the system security administrator because attributes of login accounts are set up and managed in one place.
