SQL-DMO
Logins Collection
The Logins collection contains Login objects that reference login records that form one part of Microsoft® SQL Server™ security.
Properties
| Count Property |
Methods
| Add Method | Refresh Method |
| Item Method | Remove Method (Collections) |
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 Microsoft Windows NT® security account.
For more information about creating SQL Server login records 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.