UDF Related Statement #
| Syntax | Description | Type |
|---|---|---|
| SHOW ENCRYPT UDF_ENABLED | Query encrypted UDF enabled status | RQL |
| SET ENCRYPT UDF_ENABLED = true/false | Set encrypted UDF enabled status | RDL |
| SHOW ENCRYPT PROCEDURES | Query encryption related stored procedures | RQL |
| SHOW ENCRYPT PROCEDURE procedureName | Query the specified encrypted stored procedure | RQL |
| SHOW ENCRYPT TABLE PROCEDURE tableName | Query the encrypted stored procedure associated with the specified table | RQL |
| SHOW ENCRYPT TABLE UDF tableName | Query the UDF associated with the specified table | RQL |
1. Query encrypted UDF enabled status #
SHOW ENCRYPT UDF_ENABLED
Example
mysql> SHOW ENCRYPT UDF_ENABLED;
+-------------+
| udf_enabled |
+-------------+
| false |
+-------------+
1 row in set (0.04 sec)
2. Set encrypted UDF enabled status #
SET ENCRYPT UDF_ENABLED = true | false
Example
mysql> SET ENCRYPT UDF_ENABLED = true;
Query OK, 0 rows affected (0.12 sec)
3. Query encryption related stored procedures #
SHOW ENCRYPT PROCEDURES
Example
mysql> SHOW ENCRYPT PROCEDURES;
+----------+----------------------------+----------------------------+--------------------+
| type | logic_name | actual_name | referenced_objects |
+----------+----------------------------+----------------------------+--------------------+
| FUNCTION | LOGMNR$TAB_GG_TABF_PUBLIC | LOGMNR$TAB_GG_TABF_PUBLIC | |
| FUNCTION | LOGMNR$KEY_GG_TABF_PUBLIC | LOGMNR$KEY_GG_TABF_PUBLIC | |
| FUNCTION | LOGMNR$SEQ_GG_TABF_PUBLIC | LOGMNR$SEQ_GG_TABF_PUBLIC | |
| FUNCTION | LOGMNR$GSBA_GG_TABF_PUBLIC | LOGMNR$GSBA_GG_TABF_PUBLIC | |
| FUNCTION | LOGMNR$COL_GG_TABF_PUBLIC | LOGMNR$COL_GG_TABF_PUBLIC | |
| FUNCTION | LOGMNR$USER_GG_TABF_PUBLIC | LOGMNR$USER_GG_TABF_PUBLIC | |
+----------+----------------------------+----------------------------+--------------------+
6 rows in set (0.01 sec)
4. Query the specified encrypted stored procedure #
SHOW ENCRYPT PROCEDURE procedureName
Example
mysql> SHOW ENCRYPT PROCEDURE LOGMNR$TAB_GG_TABF_PUBLIC;
+----------+---------------------------+---------------------------+--------------------+
| type | logic_name | actual_name | referenced_objects |
+----------+---------------------------+---------------------------+--------------------+
| FUNCTION | LOGMNR$TAB_GG_TABF_PUBLIC | LOGMNR$TAB_GG_TABF_PUBLIC | |
+----------+---------------------------+---------------------------+--------------------+
1 row in set (0.02 sec)
5. Query the encrypted stored procedure associated with the specified table #
SHOW ENCRYPT TABLE PROCEDURE tableName
Example
mysql> SHOW ENCRYPT TABLE PROCEDURE t_encrypt;
Empty set (0.08 sec)
6. Query the UDF associated with the specified table #
SHOW ENCRYPT TABLE UDF tableName
Example
mysql> SHOW ENCRYPT TABLE UDF t_encrypt;
+------------+-------------+--------------------------------+--------------------------------+-------------------------+---------------------+
| table_name | column_name | cipher_encryptor_name | cipher_decryptor_name | assisted_encryptor_name | like_encryptor_name |
+------------+-------------+--------------------------------+--------------------------------+-------------------------+---------------------+
| t_encrypt | order_id | SPEX_4YQXJZAYBS9GY3MD3U67R5ZS0 | SPEX_1H0NN0Y8XWOWCQN4G5M8HBC2Y | NULL | NULL |
| t_encrypt | user_id | SPEX_7MD3WMJE438VCSXYM7ZCYWQBC | SPEX_21XX6GRE4GA4O6W6NQU4IRVQ6 | NULL | NULL |
+------------+-------------+--------------------------------+--------------------------------+-------------------------+---------------------+
2 rows in set (0.13 sec)