Статья
09/28/2010

Класс SymmetricKey

The SymmetricKey object represents a SQL Server symmetric key.

Пространство имен: Microsoft.SqlServer.Management.Smo
Сборка: Microsoft.SqlServer.Smo (в Microsoft.SqlServer.Smo.dll)

Синтаксис

'Декларация
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute> _
Public NotInheritable Class SymmetricKey _
    Inherits NamedSmoObject _
    Implements IAlterable, IDroppable, IObjectPermission
'Применение
Dim instance As SymmetricKey

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

[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[PhysicalFacetAttribute]
public ref class SymmetricKey sealed : public NamedSmoObject, 
    IAlterable, IDroppable, IObjectPermission

[<SealedAttribute>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<PhysicalFacetAttribute>]
type SymmetricKey =  
    class
        inherit NamedSmoObject
        interface IAlterable
        interface IDroppable
        interface IObjectPermission
    end

public final class SymmetricKey extends NamedSmoObject implements IAlterable, IDroppable, IObjectPermission

Замечания

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

To set SymmetricKey object properties, users must have ALTER permission on the symmetric key.

To create a symmetric key, users must have ALTER ANY SYMMETRIC KEY permissions on the parent database.

To drop a symmetric key, users must have CONTROL permissions on the symmetric key.

To open the symmetric key, users must know the password used to encrypt the symmetric key. CONTROL permission is also required on the certificate or other symmetric key when used to open the specified symmetric key.

To grant, deny, or revoke permissions on the symmetric key to other users, users must have CONTROL permissions on the symmetric key.