Oracle | DBMS_UMF

Oracle DBMS_UMF_PROTECTED 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 Universal Message Format, UMF, Provides an interface for deploying the Remote Management Framework (RMF) for an Oracle Database. The RMF is used for collecting Oracle Database performance statistics. It provides functions to create and manage UMF topologies. Specifically, it provides calls to create/drop topologies and to modify a topology by adding/removing nodes and links. It also provides calls to manage services (such as AWR) running on nodes and to view/validate a topology. API calls for a given topology must be executed on the target for that topology. This is an internal package supporting DBMS_UMF.

AUTHID DEFINER

Data Types TYPE psf_binds_type ... TYPE psf_defines_type ... TYPE numberpsf_num_array_type ... TYPE umf_finds_type ...

Dependencies

AWRRPT_INSTANCE_LIST_TYPE	DBMS_SQL	DBMS_UMF_INTERNAL
AWRRPT_NUMBER_LIST_TYPE	DBMS_STANDARD	DBMS_UMF_LIB
DBMS_ASH_INTERNAL	DBMS_SWRF_REPORT_INTERNAL	DBMS_WORKLOAD_REPOSITORY
DBMS_AWR_REPORT_LAYOUT	DBMS_SYSTEM	PLITBLM
DBMS_LOB

Documented No

First Available 12.2

Security Model Owned by SYS with no privileges granted.

Direct access to this package is prevented by means of an Accessible By clause.

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

Subprograms

PSF_ADD_BIND	PSF_EXECUTE_QUERY	PSF_INIT_BINDS
PSF_CQCX_FINALIZE	PSF_GET_DEFINE	PSF_INIT_DEFINES
PSF_CQCX_INIT	PSF_GET_ENV_FLAG_BY_DBID	PSF_SUBSTITUTE_PAT
PSF_CREATE_INSTANTIATION_PAT	PSF_ICXC_INIT	PSF_SUBSTITUTE_PAT2
PSF_DEFINE_COLUMNS	PSF_ICXC_SET	PSF_TRANSFORM_VCHAR

PSF_ADD_BIND

Undocumented

Overload 1 dbms_umf_protected.psf_add_bind( bind_type IN BINARY_INTEGER, bind_value IN NUMBER, binds IN OUT dbms_umf_protected.umf_binds_type);

TBD

Overload 2 dbms_umf_protected.psf_add_bind( bind_type IN BINARY_INTEGER, bind_value IN sys.awrrpt_instance_list_type, binds IN OUT dbms_umf_protected.umf_binds_type);

TBD

Overload 3 dbms_umf_protected.psf_add_bind( bind_type IN BINARY_INTEGER, bind_value IN sys.awrrpt_number_list_type, binds IN OUT dbms_umf_protected.umf_binds_type);

TBD

Overload 4 dbms_umf_protected.psf_add_bind( bind_type IN BINARY_INTEGER, bind_value IN VARCHAR2, binds IN OUT dbms_umf_protected.umf_binds_type);

TBD

Overload 5 dbms_umf_protected.psf_add_bind( bind_type IN BINARY_INTEGER, bind_value IN TIMESTAMP, binds IN OUT dbms_umf_protected.umf_binds_type);

TBD

Overload 6 dbms_umf_protected.psf_add_bind( bind_type IN BINARY_INTEGER, bind_value IN dbms_umf_protected.psf_num_array_type, binds IN OUT dbms_umf_protected.umf_binds_type);

TBD

Overload 7 dbms_umf_protected.psf_add_bind( bind_type IN BINARY_INTEGER, bind_value IN DATE, binds IN OUT dbms_umf_protected.umf_binds_type);

TBD

PSF_CQCX_FINALIZE

Undocumented dbms_umf_protected.psf_cqcx_finalize(psf_cqcx IN OUT sys.dbms_umf_protected.psf_cqcx_type);

TBD

PSF_CQCX_INIT

Undocumented dbms_umf_protected.psf_cqcx_init( psf_cqcx IN OUT sys.dbms_umf_protected.psf_cqcx_type, str_in IN CLOB, evn_flag IN BINARY_INTEGER, icx_coll IN sys.dbms_umf_protected.psf_icxc_type);

TBD

PSF_CREATE_INSTANTIATION_PAT

Undocumented dbms_umf_protected.psf_create_instantiation_pat(iid IN BINARY_INTEGER) RETURN VARCHAR2;

TBD

PSF_DEFINE_COLUMNS

Undocumented dbms_umf_protected.psf_define_columns( defs IN OUT dbms_umf_protected.psf_define_type, offset IN BINARY_INTEGER, amount IN BINARY_INTEGER, dtype IN BINARY_INTEGER);

TBD

PSF_EXECUTE_QUERY

Undocumented dbms_umf_protected.psf_execute_query( cursor_str_in IN CLOB, query_type IN BINARY_INTEGER, defs IN OUT dbms_umf_protected.psf_defines_type, binds IN dbms_umf_protected.psf_binds_type, env_flag IN BINARY_INTEGER) RETURN NUMBER;

TBD

PSF_GET_DEFINE

Undocumented

Overload 1 dbms_umf_protected.psf_get_define( defs IN dbms_umf_protected.psf_defines_type, idx IN BINARY_INTEGER, var IN OUT NUMBER);

TBD

Overload 2 dbms_umf_protected.psf_get_define( defs IN dbms_umf_protected.psf_defines_type, idx IN BINARY_INTEGER, var IN OUT VARCHAR2);

TBD

Overload 3 dbms_umf_protected.psf_get_define( defs IN dbms_umf_protected.psf_defines_type, idx IN BINARY_INTEGER, var IN OUT TIMESTAMP);

TBD

Overload 4 dbms_umf_protected.psf_get_define( defs IN dbms_umf_protected.psf_defines_type, idx IN BINARY_INTEGER, var IN OUT DATE);

TBD

Overload 5 dbms_umf_protected.psf_get_define( defs IN dbms_umf_protected.psf_defines_type, idx IN BINARY_INTEGER, var IN OUT awrrpt_instance_list_type);

TBD

PSF_GET_ENV_FLAG_BY_DBID

Undocumented dbms_umf_protected.psf_get_env_flag_by_dbid( l_dbid IN NUMBER) RETURN BINARY_INTEGER;

Protected by ACCESSIBLE BY clause as demonstrated here.

      

      SQL> SELECT dbid FROM v$database;

      

            DBID

      ----------

       768045447

      

      SQL> SELECT dbms_umf_protected.psf_get_env_flag_by_dbid(768045447)

        2  FROM dual;

      SELECT dbms_umf_protected.psf_get_env_flag_by_dbid(768045447)

      *

      ERROR at line 1:

      ORA-06553: PLS-904: insufficient privilege to access object DBMS_UMF_PROTECTED

      

      SQL> sho user

      USER is "SYS"

      

       CON_ID

      -------

            1

PSF_ICXC_INIT

Undocumented dbms_umf_protected.psf_icxc_init(icx_coll IN OUT sys.dbms_umf_protected.psf_icxc_type);

TBD

PSF_ICXC_SET

Undocumented dbms_umf_protected.psf_icxc_set( icx_coll IN OUT sys.dbms_umf_protected.psf_icxc_type, iid IN BINARY_INTEGER, ds_ver_type IN BINARY_INTEGER);

TBD

PSF_INIT_BINDS

Undocumented dbms_umf_protected.psf_init_binds(binds IN OUT dbms_umf_protected.psf_binds_type);

TBD

PSF_UMF_DEFINES

Undocumented dbms_umf_protected.psf_umf_defines(defs IN OUT dbms_umf_protected.psf_defines_type);

TBD

PSF_SUBSTITUTE_PAT

Undocumented dbms_umf_protected.psf_substitute_pat( sql_str_in_clob IN CLOB, sql_str_out IN OUT CLOB, env_flag IN BINARY_INTEGER);

TBD

PSF_SUBSTITUTE_PAT2

Undocumented dbms_umf_protected.psf_substitute_pat2(psf_cqcx IN OUT sys.dbms_umf_protected.psf_cqcx_type);

TBD

PSF_TRANSFORM_VCHAR

Undocumented dbms_umf_protected.psf_transform_vchar( str IN OUT VARCHAR2, max_len IN NUMBER, env_flag IN BINARY_INTEGER);

TBD