系统会为 SQL 数据库自动创建一个数据库加密密钥。 用户无需使用 CREATE DATABASE ENCRYPTION KEY 语句创建密钥。 权限 需要数据库的 CONTROL 权限和用于加密数据库加密密钥的证书或非对称密钥的 VIEW DEFINITION 权限。 示例 有关使用 TDE 的其他示例,请参阅透明数据加密 (TDE)、使用 EKM 在
CreateDatabaseEncryptionKeyStatement CreateDatabaseEncryptionKeyStatement 建構函式 方法 CreateDatabaseStatement CreateDefaultStatement CreateEndpointStatement CreateEventNotificationStatement CreateEventSessionStatement CreateExternalDataSourceStatement CreateExternalFileFormatStatement CreateExternalResourceP...
CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = { AES_128 | AES_192 | AES_256 | TRIPLE_DES_3KEY } ENCRYPTION BY SERVER { CERTIFICATE Encryptor_Name | ASYMMETRIC KEY Encryptor_Name } [ ; ] Arguments WITH ALGORITHM = { AES_128 | AES_192 | AES_256 | TRIPLE_DES_3KEY } Specifies the...
CreateDatabaseEncryptionKey 属性 CreateDefault 属性 CreateEventNotification 属性 CreateExtendedProperty 属性 CreateFulltextCatalog 属性 CreateFulltextIndex 属性 CreateFulltextStoplist 属性 CreateFunction 属性 CreateIndex 属性 CreateMasterKey 属性 CreateMessageType 属性 CreatePartitionFunction 属性 ...
CREATE DATABASE mydb ENCRYPT CIPHER AES KEY LENGTH 192 MASTER KEY LABEL mylabel.mydb.myinstance.myserver; 使用注意事項 CREATE DATABASE 指令: 在指定的子目錄中建立資料庫。 在分割的資料庫環境中,在 db2nodes.cfg列出的所有資料庫分割區上建立資料庫,並在每一個資料庫分割區的指定子目錄下建立 $DB2INS...
Create the service key: create encryption key syb_extpasswdkey [ with { static key | master key }] create encryption key syb_syscommkey [ with { static key | master key }] Create the column encryption key: create encryption key [[<database>.][<owner>].]<keyname> [as default] [...
CREATE DATABASE (Transact-SQL) CREATE DATABASE AUDIT SPECIFICATION (Transact-SQL) CREATE DATABASE ENCRYPTION KEY (Transact-SQL) CREATE DEFAULT (Transact-SQL) CREATE ENDPOINT (Transact-SQL) CREATE EVENT NOTIFICATION (Transact-SQL) CREATE EVENT SESSION (Transact-SQL) CREATE FULLTEXT CATALOG (Transact-...
CREATE DATABASE AUDIT SPECIFICATION (Transact-SQL) CREATE DATABASE ENCRYPTION KEY (Transact-SQL) CREATE DEFAULT (Transact-SQL) CREATE ENDPOINT (Transact-SQL) CREATE EVENT NOTIFICATION (Transact-SQL) CREATE EVENT SESSION (Transact-SQL) CREATE FULLTEXT CATALOG (Transact-SQL) ...
DATABASE ENCRYPTION KEY DATABASE SCOPED CREDENTIAL DEFAULT ENDPOINT EVENT NOTIFICATION EVENT SESSION EXTERNAL DATA SOURCE EXTERNAL DATA SOURCE CONNECTION_OPTIONS EXTERNAL LANGUAGE EXTERNAL LIBRARY EXTERNAL FILE FORMAT EXTERNAL RESOURCE POOL EXTERNAL TABLE EXTERNAL TABLE AS SELECT FULLTEXT CATALOG FULLTEXT INDEX...
CREATEASYMMETRICKEYasym_key_name[AUTHORIZATIONdatabase_principal_name] [FROM<asym_key_source>] [WITH<key_option>] [ENCRYPTIONBY<encrypting_mechanism>] [ ; ]<asym_key_source>::=FILE='path_to_strong-name_file'|EXECUTABLEFILE='path_to_executable_file'|ASSEMBLYassembly_name|PROVIDERprovider_name<ke...