Logins Collection
Questa funzionalità verrà rimossa in una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.
The Logins collection contains Login objects that reference login records that form one part of Microsoft SQL Server security.
Properties
Methods
Osservazioni
With the Logins collection, you can:
- Create SQL Server login records used for SQL Server Authentication or used by Windows Authentication for security account identification.
- Remove login records, disabling SQL Server Authentication for the login or removing configured behavior for a Windows 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("someone")
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("somebody")
Or:
Set oLogin = oSQLServer.Logins(1)
[!NOTA] 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.