Oracle | DBMS_SQADM

Oracle DBMS_SQADM_SYSCALLS 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 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