Logins Editor (SQL Server)

Go Up to Microsoft SQL Server Object Editors

The Logins Editor lets you manage basic properties for a login, associated users and roles, and accounting.

To edit a login:

1. Open an editor on the login. For details, see Opening an Object Editor.
2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:

Tab	Settings and tasks
Properties	Lets you view or modify the following properties set when creating the login: Name, Default Database, Default Language, Password, Check Policy, Check Expiration, Must Change, Certificate, and Asymmetric Key. For detailed information on these settings, see Logins Wizard (SQL Server). In addition, when editing an existing login, you have access to the following settings:
	Currently Logged In	Displays whether the user is currently logged in.
	Enabled	Enabled, an ALTER LOGIN... ENABLE is submitted following the CREATE LOGIN statement issued by the editor. Disabled, an ALTER LOGIN... DISABLE is submitted
Server Roles	Lets you add the login as a member of one or more fixed server roles. For more information, see Logins (SQL Server) - Server Roles.
Users	Lets you add and remove user accounts for this login to specified databases. For more detailed information, see Logins (SQL Server) - Users.
DDL	For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.