Dela via


Credential Class

The Credential object represents a Microsoft SQL Server credential.

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

Syntax

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

Remarks

Credentials provide SQL Server authenticated users with an identity outside of SQL Server, on the local machine or on the network domain.

Credentials can also be used when a SQL Server authenticated user needs access to a domain resource, such as a file location to store a backup.

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

To set Credential object properties and run the Alter method, users must have ALTER ANY CREDENTIAL permission on the parent server, or be a member of the sysadmin fixed server role.

To create a credential, users must have ALTER ANY CREDENTIAL permission on the parent server, or be a member of the sysadmin fixed server role.

To drop a credential, users must have ALTER ANY CREDENTIAL permission on the parent server, or 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.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.SmoObjectBase
    Microsoft.SqlServer.Management.Smo.SqlSmoObject
      Microsoft.SqlServer.Management.Smo.NamedSmoObject
        Microsoft.SqlServer.Management.Smo.Credential

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.