General Information
Library Note
Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx .
Purpose
Advanced Queuing Related Management Utilities
AUTHID
CURRENT_USER
Dependencies
DBMS_AQADM_INV
DBMS_ASSERT
DBMS_SYSTEM
DBMS_AQADM_SYS
DBMS_PRVTSQDS
DBMS_SYS_ERROR
DBMS_AQADM_SYSCALLS
DBMS_PRVTSQIS
EXPDEPOBJ$
DBMS_AQ_SYS_EXP_INTERNAL
DBMS_RULE_ADM
Documented
No
First Available
12.1
Security Model
Owned by SYS with no privileges granted
Source
{ORACLE_HOME}/rdbms/admin/dbmssqds.plb
{ORACLE_HOME}/rdbms/admin/prvtsqds.plb
Subprograms
ADDQUERULE
Undocumented
dbms_prvtsqds.addQueRule(
rsschema IN VARCHAR2,
rsname IN VARCHAR2,
qobjn IN NUMBER,
qschema IN VARCHAR2,
qname IN VARCHAR2,
ruleschema IN VARCHAR2,
rulename IN VARCHAR2,
rulecond IN VARCHAR2);
TBD
ALTERSUBRULE
Undocumented
dbms_prvtsqds.alterSubRule(
ruleschema IN VARCHAR2,
rulename IN VARCHAR2,
rulecond IN VARCHAR2);
TBD
CHECKANDDROPRULE
Undocumented
dbms_prvtsqds.checkAndDropRule(
qschema IN VARCHAR2,
qname IN VARCHAR2,
qtobjn IN NUMBER,
ruleschema IN VARCHAR2,
rulename IN VARCHAR2);
TBD
CHECKDUPLRULECOND
Undocumented
dbms_prvtsqds.checkDuplRuleCond(
rsschema IN VARCHAR2,
rsname IN VARCHAR2,
rulecond IN VARCHAR2,
rulename OUT VARCHAR2)
RETURN BOOLEAN;
TBD
CREATEEXPIMPDEP
Undocumented
dbms_prvtsqds.createExpImpDep(
pobjnum IN NUMBER,
depobjnum IN NUMBER);
TBD
CREATESQRULESET
Undocumented
dbms_prvtsqds.createSqRuleSet(
rsschema IN VARCHAR2,
rsname IN VARCHAR2,
qobjn IN NUMBER);
TBD
CREATETMT
Undocumented
dbms_prvtsqds.createTmt(
qschema IN VARCHAR2,
qname IN VARCHAR2,
qflags IN NUMBER,
sortord IN NUMBER,
storage IN VARCHAR2);
TBD
CREATE_RULE_SEQUENCE
Undocumented
dbms_prvtsqds.create_rule_sequence(
qschema IN VARCHAR2,
qname IN VARCHAR2);
TBD
DROPQUERULE
Undocumented
dbms_prvtsqds.dropQueRule(
qtobjn IN NUMBER,
rsschema IN VARCHAR2,
rsname IN VARCHAR2,
ruleschema IN VARCHAR2,
rulename IN VARCHAR2);
TBD
DROPTMT
Undocumented
dbms_prvtsqds.dropTmt(
qschema IN VARCHAR2,
qname IN VARCHAR2,
ignore_ddl_error IN BOOLEAN);
TBD
DROP_RULE_SEQUENCE
Undocumented
dbms_prvtsqds.drop_rule_sequence(
qschema IN VARCHAR2,
qname IN VARCHAR2,
ignoreerr IN BOOLEAN);
TBD
GETNUMQUESAMERULE
Undocumented
dbms_prvtsqds.getNumQueSameRule(
qschema IN VARCHAR2,
qname IN VARCHAR2,
rulename IN VARCHAR2)
RETURN NUMBER;
TBD
GETOBJNUMBER
Undocumented
dbms_prvtsqds.getObjNumber(
schema IN VARCHAR2,
name IN VARCHAR2,
objtype IN NUMBER,
objnum OUT NUMBER);
TBD
GETQUEUERULESET
Undocumented
dbms_prvtsqds.getQueueRuleSet(
qname IN VARCHAR2,
rsname OUT VARCHAR2);
TBD