Oracle DBMS_PRVTSQDS
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx