| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Advanced Queueing Export Privilege Checking |
| AUTHID |
CURRENT_USER |
| Dependencies |
| DBMS_AQ_EXP_CMT_TIME_TABLES |
DBMS_AQ_EXP_SIGNATURE_TABLES |
| DBMS_AQ_EXP_DEQUEUELOG_TABLES |
DBMS_AQ_EXP_SUBSCRIBER_TABLES |
| DBMS_AQ_EXP_HISTORY_TABLES |
DBMS_AQ_EXP_TIMEMGR_TABLES |
| DBMS_AQ_EXP_INDEX_TABLES |
DBMS_AQ_SYS_EXP_INTERNAL |
| DBMS_AQ_EXP_QUEUES |
DBMS_ZHELP_IR |
| DBMS_AQ_EXP_QUEUE_TABLES |
|
|
| Documented |
No |
| First Available |
Not Known |
| Security Model |
Owned by SYS with no privileges granted |
| Source |
{ORACLE_HOME}/rdbms/admin/prvtaqxi.plb |
| |
| CHECK_EXPORT_PRIV |
Validates the user has AQ export privileges
Overload 1 |
dbms_aq_exp_zecurity.check_export_priv(obj_schema IN VARCHAR2); |
exec dbms_aq_exp_zecurity.check_export_priv('C##SH');
PL/SQL procedure successfully completed. |
| Overload 2 |
dbms_aq_exp_zecurity.check_export_priv(obj_id IN NUMBER); |
SELECT object_name, object_id
FROM dba_objects
WHERE owner = 'C##SH'
AND rownum < 11
ORDER BY 1;
OBJECT_NAME OBJECT_ID
-------------------- ----------
ADDRESS_TYPE 77427
CAL_MONTH_SALES_MV 76449
CAL_MONTH_SALES_MV 76759
CHANNELS 76450
CHANNELS_DIM 76764
CHANNELS_PK 76451
COSTS 76452
COSTS 76453
COSTS 76454
COSTS 76455
exec dbms_aq_exp_zecurity.check_export_priv(76453);
PL/SQL procedure successfully completed. |