Oracle DBMS_UMF_PROTECTED
Version 19c

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 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.

This object is protected by an ACCESSIBLE BY clause so no working demos are possible.
Source {ORACLE_HOME}/rdbms/admin/prvsumfi.plb
Subprograms
 
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_UMF
DBMS_UMF_INTERNAL
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