Oracle | DBMS_PRVTSQDS

Oracle DBMS_PRVTSQDS Version 21c

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	CREATESQRULESET	DROP_RULE_SEQUENCE
ALTERSUBRULE	CREATETMT	GETNUMQUESAMERULE
CHECKANDDROPRULE	CREATE_RULE_SEQUENCE	GETOBJNUMBER
CHECKDUPLRULECOND	DROPQUERULE	GETQUEUERULESET
CREATEEXPIMPDEP	DROPTMT

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