This topic has not yet been rated - Rate this topic

Certificate Class

SQL Server 2008

The Certificate object represents a SQL Server certificate.

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

Syntax

C++

JScript

[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[PhysicalFacetAttribute]
public sealed class Certificate : NamedSmoObject, 
	ICreatable, IDroppable, IAlterable, IObjectPermission

Remarks

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

To set the Certificate object properties and run the Alter method, users must have ALTER permission on the certificate.

To create a Certificate object, users must have CREATE CERTIFICATE permission on the parent database.

To drop a Certificate object, users must have CONTROL permission on the certificate.

To grant, deny, or revoke permission to other users on the Certificate object, users must have CONTROL permission on the certificate.

Examples

Using Encryption

Inheritance Hierarchy

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

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.

Reference

Certificate Members

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Encryption Hierarchy

CREATE CERTIFICATE (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD