Oracle | DBMS_SQADM

Oracle DBMS_SQADM_SYSCALLS 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 Support for Automatic Diagnostic Repository (ADR)

AUTHID DEFINER

Dependencies

DBMS_AQINT_LIB

DBMS_PRVTSQIS

DBMS_SQADM_LIB

Documented No

First Available 12.1

Security Model Owned by SYS with

Source {ORACLE_HOME}/rdbms/admin/dbmssqds.plb

Subprograms

KWSA_3GL_ADDCSUB	KWSA_3GL_CRTDRPDSUBKGLSCQ	KWSA_3GL_LOCKDSUB
KWSA_3GL_ADDDSUB	KWSA_3GL_DRPCSUB	KWSA_3GL_LOCKDSUBN
KWSA_3GL_ALTERDSUB	KWSA_3GL_DRPDSUB

KWSA_3GL_ADDCSUB

Undocumented dbms_sqadm_syscalls.kwsa_3gl_addCSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub_name IN VARCHAR2, sub_id IN NUMBER, pos_bmap OUT NUMBER, create_time IN TIMESTAMP WITH TIME ZONE, flags OUT NUMBER, parent_id OUT NUMBER, parent IN VARCHAR2);

TBD

KWSA_3GL_ADDDSUB

Undocumented dbms_sqadm_syscalls.kwsa_3gl_addDSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub_name IN VARCHAR2, sub_addr IN VARCHAR2, sub_prot IN NUMBER, sub_id IN NUMBER, pos_bmapP OUT NUMBER, rule_name IN VARCHAR2, trans_sch IN VARCHAR2, trans_name IN VARCHAR2, create_time IN TIMESTAMP WITH TIME ZONE, flags IN NUMBER);

TBD

KWSA_3GL_ALTERDSUB

Undocumented dbms_sqadm_syscalls.kwsa_3gl_alterDSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub_name IN VARCHAR2, rule_name IN VARCHAR2, trans_sch IN VARCHAR2, trans_name IN VARCHAR2, updrule IN BOOLEAN, updtrans IN BOOLEAN);

TBD

KWSA_3GL_CRTDRPDSUBKGLSCQ (new 21c)

Undocumented dbms_sqadm_syscalls.kwsa_3gl_crtDrpDSubKGLSCQ(

TBD

KWSA_3GL_DRPCSUB

Undocumented dbms_sqadm_syscalls.kwsa_3gl_drpCSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub_name IN VARCHAR2, sub_addr IN VARCHAR2, sub_prot IN NUMBER, sub_id IN NUMBER, qid IN NUMBER, par_name IN VARCHAR2);

TBD

KWSA_3GL_DRPDSUB

Undocumented dbms_sqadm_syscalls.kwsa_3gl_drpDSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, sub_name IN VARCHAR2, sub_addr IN VARCHAR2, sub_prot IN NUMBER, sub_id IN NUMBER, qid IN NUMBER);

TBD

KWSA_3GL_LOCKDSUB

Undocumented dbms_sqadm_syscalls.dbms_sqadm_syscalls.kwsa_3GL_LockDSub( q_schema IN VARCHAR2, q_name IN VARCHAR2, operation IN VARCHAR2, flags IN BINARY_INTEGER);

TBD

KWSA_3GL_LOCKDSUBN (new 21c)

Undocumented dbms_sqadm_syscalls.kwsa_3gl_lockDSubn(

TBD