Login Accounts can be managed with login profiles that define attributes for individual logins, a subset of logins, or all logins.
Login Profiles
A login profile is a collection of attributes specific to login accounts. You can manage attributes of login accounts by creating login profiles and associating the profile with a login account. You can manage attributes of a large number of login accounts by defining login profile as: the default for all login accounts, a subset of login accounts, or individual login accounts.
Note: Login profiles are supported in multiple-server or a single-server environments.
Options for Creating or Modifying Login Profiles
When you create or modify a login profile, you can :
- Assign a default database and default language
- Assign an authentication mechanism
- Track the last login
- Define a stale login inactivity period
- Execute a login script
Login Profile Precedence Rules
Login profiles attributes are associated with login accounts using this precedence:
- Attribute values from a login profile bound to the login
- Attribute values from a default login profile
- Values that have been specified using sp_passwordpolicy under these circumstances:
- A default login profile does not exist
-
A login profile has not been defined and bound to the account
- The login profile is set to be ignored
- The default value for the attribute