sys.column_encryption_keys (Transact-sql) sys.column_encryption_keys (Transact-SQL)

適用於: SQL Server 2016 和更新版本 Azure SQL Database Azure Synapse Analytics 平行處理資料倉儲

傳回資料行加密金鑰的相關資訊 (使用 CREATE COLUMN ENCRYPTION KEY 語句建立的 cek) 。Returns information about column encryption keys (CEKs) created with the CREATE COLUMN ENCRYPTION KEY statement. 每個資料列都代表 CEK。Each row represents a CEK.

資料行名稱Column name 資料類型Data type 描述Description
namename sysnamesysname CEK 的名稱。The name of the CEK.
column_encryption_key_idcolumn_encryption_key_id intint CEK 的識別碼。ID of the CEK.
create_datecreate_date datetimedatetime CEK 的建立日期。Date the CEK was created.
modify_datemodify_date datetimedatetime 上次修改 CEK 的日期。Date the CEK was last modified.

權限Permissions

需要 VIEW ANY COLUMN ENCRYPTION KEY 許可權。Requires the VIEW ANY COLUMN ENCRYPTION KEY permission.

目錄檢視內中繼資料的可見性會限制在使用者所擁有的安全性實體,或已授與使用者某些權限的安全性實體。The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. 如需相關資訊,請參閱 Metadata Visibility ConfigurationFor more information, see Metadata Visibility Configuration.

另請參閱See Also

CREATE COLUMN ENCRYPTION KEY (Transact-SQL) CREATE COLUMN ENCRYPTION KEY (Transact-SQL)
ALTER COLUMN ENCRYPTION KEY (Transact-SQL) ALTER COLUMN ENCRYPTION KEY (Transact-SQL)
DROP COLUMN ENCRYPTION KEY (Transact-SQL) DROP COLUMN ENCRYPTION KEY (Transact-SQL)
CREATE COLUMN MASTER KEY (Transact-SQL) CREATE COLUMN MASTER KEY (Transact-SQL)
安全性目錄檢視 (Transact-SQL) Security Catalog Views (Transact-SQL)
sys.column_encryption_key_values (Transact-SQL)sys.column_encryption_key_values (Transact-SQL)
Always Encrypted Always Encrypted
具有安全記憶體保護區的 Always Encrypted Always Encrypted with secure enclaves
Always Encrypted 的金鑰管理概觀 Overview of Key Management for Always Encrypted
為具有安全記憶體保護區的 Always Encrypted 管理金鑰Manage keys for Always Encrypted with secure enclaves