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.
See Also