Login Object (SQL-DMO)

The Login object exposes the attributes of a single SQL Server Authentication record.

Remarks

Microsoft® SQL Server™ uses two ways to validate connections to SQL Server databases: Windows NT Authentication and SQL Server Authentication. SQL Server Authentication uses login records to validate the connection. A Login object exposes a SQL Server login record.

With a Login object, you can:

• Create a SQL Server login record for a SQL Server Authentication connection.
• Set the attributes of a SQL Server login record, such as the password or the default database for the login.
• Determine the role membership of a SQL Server login.
• Remove a login record from SQL Server, disabling its use.

Note To view, create, or remove SQL Server logins by using the Login object, the connected user must be a member of the SQL Server securityadmin fixed server role.

The Name property of a Login object uses the SQL Server data type sysname. The value of the Name property must be unique for a server running SQL Server.

A SQL Server login is created with no password and no rights to any database on the server. After successful creation of a SQL Server login, you can use the SetPassword method of the Login object to assign a password to the login. Use the Database User object and Users collection to grant login access to server resources.

To add a login to a server running SQL Server

1. Create a Login object.
2. Set the Name property.
3. Set the Type property. By default, a login is created for use by SQL Server Authentication. Alternately specify the login type to map a Microsoft Windows NT® user or group.
4. Add the Login object to the Logins collection of a connected SQLServer object to create the SQL Server login.

Methods

Properties

See Also

Managing Security