Login Class

The Login object represents a SQL Server login account that has been granted access to the instance of SQL Server through Windows Authentication or SQL Server Authentication.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<PhysicalFacetAttribute> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
Public NotInheritable Class Login _
    Inherits ScriptNameObjectBase _
    Implements IObjectPermission, ICreatable, IAlterable, IDroppable,  _
    IRenamable, IScriptable, ILoginOptions, IDmfFacet
'Usage
Dim instance As Login
[PhysicalFacetAttribute]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
public sealed class Login : ScriptNameObjectBase, 
    IObjectPermission, ICreatable, IAlterable, IDroppable, IRenamable, 
    IScriptable, ILoginOptions, IDmfFacet
[PhysicalFacetAttribute]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
public ref class Login sealed : public ScriptNameObjectBase, 
    IObjectPermission, ICreatable, IAlterable, IDroppable, IRenamable, 
    IScriptable, ILoginOptions, IDmfFacet
[<SealedAttribute>]
[<PhysicalFacetAttribute>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
type Login =  
    class
        inherit ScriptNameObjectBase
        interface IObjectPermission
        interface ICreatable
        interface IAlterable
        interface IDroppable
        interface IRenamable
        interface IScriptable
        interface ILoginOptions
        interface IDmfFacet
    end
public final class Login extends ScriptNameObjectBase implements IObjectPermission, ICreatable, IAlterable, IDroppable, IRenamable, IScriptable, ILoginOptions, IDmfFacet

Remarks

To get Login object properties, users can be a member of the public fixed server role.

To set Login object properties, users must have ALTER ANY LOGIN permissions on the server or be a member of the sysadmin fixed server role.

To create or drop a login, users must have ALTER ANY LOGIN permissions on the server or be a member of the sysadmin fixed server role.

To grant, deny, or revoke permission on the login to other users, users must have CONTROL permissions on the logon or be a member of the sysadmin or securityadmin fixed server roles.

To set the password on a login without providing an old password, users must be a member of the sysadmin fixed server role.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.