Logins Collection (SQL-DMO)

The Logins collection contains Login objects referencing login records that form one part of Microsoft® SQL Server™ security.

Remarks

With the Logins collection, you can:

• Create SQL Server login records used for SQL Server Authentication or used by Windows NT Authentication for security account identification.
• Remove login records, disabling SQL Server Authentication for the login or removing configured behavior for a Windows NT security account.

For more information about creating SQL Server login records by using the Login object and Logins collection, see Login Object.

To remove a login record

• Use the Remove method of the Logins collection, as in:

    oSQLServer.Logins.Remove("anned")

When using the Item or Remove method, the Logins collection supports member identification using either name or ordinal reference syntax. For example:

Set oLogin = oSQLServer.Logins("stevenb")

Or:

Set oLogin = oSQLServer.Logins(1)

Note Creating or removing SQL Server logins by using the Logins collection requires appropriate privilege. The SQL Server login used for SQLServer object connection must be a member of the fixed role securityadmin or a role with greater privilege.

Methods

Properties

Count Property