getClusterTDEKeys

Syntax

getClusterTDEKeys()

Arguments

None

Details

[Linux Only] This function retrieves encryption information for encrypted tables in the cluster.

Return value: It returns a table with the following columns:

  • tableName: name of the encrypted table.
  • mode: encryption mode in uppercase.
  • version: TDE key version.

Note: When executed by an administrator or a user with DB_MANAGE privileges, the function returns encryption information for all encrypted tables in the cluster. Otherwise, it only returns encryption information for tables that the user has access to. Access privileges include: DB_MANAGE, DBOBJ_CREATE, DB_OWNER, TABLE_READ, TABLE_WRITE, TABLE_INSERT, TABLE_UPDATE, TABLE_DELETE, DB_READ, DB_WRITE, DB_INSERT, DB_UPDATE, DB_DELETE.

Examples

getClusterTDEKeys()
tableName mode version
dfs://db/table1 AES_128_CTR 3,698,850,997
dfs://db/table2 AES_128_CTR 5,768,669,747