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
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 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx