Jaa

SymmetricKey Class

  • Artikkeli

The SymmetricKey object represents a Microsoft SQL Server symmetric key.

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

Syntax

'Declaration
Public NotInheritable Class SymmetricKey
    Inherits NamedSmoObject
    Implements IAlterable, IDroppable, IObjectPermission

public sealed class SymmetricKey : NamedSmoObject, IAlterable, IDroppable, IObjectPermission

public ref class SymmetricKey sealed : public NamedSmoObject, IAlterable, IDroppable, IObjectPermission

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

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

Remarks

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

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.

Inheritance Hierarchy

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

Thread Safety

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

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

SymmetricKey Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Using Encryption
Encryption Hierarchy
CREATE SYMMETRIC KEY (Transact-SQL)