Logo
Oracle Stored procedure encryption
SyntaxDescriptionType
SHOW ENCRYPT UDF_ENABLEDQuery encrypted UDF enabled statusRQL
SET ENCRYPT UDF_ENABLED = true/falseSet encrypted UDF enabled statusRDL
SHOW ENCRYPT PROCEDURESQuery encryption related stored proceduresRQL
SHOW ENCRYPT PROCEDURE procedureNameQuery the specified encrypted stored procedureRQL
SHOW ENCRYPT TABLE PROCEDURE tableNameQuery the encrypted stored procedure associated with the specified tableRQL
SHOW ENCRYPT TABLE UDF tableNameQuery the UDF associated with the specified tableRQL

1. Query encrypted UDF enabled status #

copySHOW ENCRYPT UDF_ENABLED

Example

copymysql> SHOW ENCRYPT UDF_ENABLED;
+-------------+
| udf_enabled |
+-------------+
| false       |
+-------------+
1 row in set (0.04 sec)

2. Set encrypted UDF enabled status #

copySET ENCRYPT UDF_ENABLED = true | false

Example

copymysql> SET ENCRYPT UDF_ENABLED = true;
Query OK, 0 rows affected (0.12 sec)

copySHOW ENCRYPT PROCEDURES

Example

copymysql> 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 #

copySHOW ENCRYPT PROCEDURE procedureName

Example

copymysql> 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 #

copySHOW ENCRYPT TABLE PROCEDURE tableName

Example

copymysql> SHOW ENCRYPT TABLE PROCEDURE t_encrypt;
Empty set (0.08 sec)

6. Query the UDF associated with the specified table #

copySHOW ENCRYPT TABLE UDF tableName

Example

copymysql> 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)