Oracle | DBMS_HS

Oracle DBMS_HS_CHK 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 Undocumented

AUTHID DEFINER

Dependencies

DBMS_HS	HS$_CLASS_CAPS	HS$_FDS_INST
DBMS_HS_ALT	HS$_CLASS_DD	HS$_INST_CAPS
DBMS_HS_UTL	HS$_CLASS_INIT	HS$_INST_DD
HS$_BASE_CAPS	HS$_FDS_CLASS	HS$_INST_INIT
HS$_BASE_DD

Documented No

Exceptions

Error Code	Reason
ORA-24274	no row exists in the HS$_BASE_DD table for these parameters

First Available Not known

Security Model Owned by SYS with no privileges granted

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

Subprograms

CHECK_BASE_CAPS	CHECK_FDS_CLASS	CHECK_INST_DD
CHECK_BASE_DD	CHECK_FDS_INST	CHECK_INST_INIT
CHECK_CLASS_CAPS	CHECK_INIT_VALUE_TYPE	CHECK_TRANSLATION_TEXT
CHECK_CLASS_DD	CHECK_INST_CAPS	CHECK_TRANSLATION_TYPE
CHECK_CLASS_INIT

CHECK_BASE_CAPS

Undocumented dbms_hs_chk.check_base_caps(cap_number IN NUMBER) RETURN NUMBER;

TBD

CHECK_BASE_DD

Checks to determine whether a table is listed in HS$_BASE_DD dbms_hs_chk.check_base_dd(dd_table_name IN VARCHAR2) RETURN NUMBER;

SELECT dbms_hs_chk.check_base_dd('TAB$')

      FROM dual;

      SELECT dbms_hs_chk.check_base_dd('TAB$')

      *

      ERROR at line 1:

      ORA-24274: no row exists in the HS$_BASE_DD table for these parameters

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86

      ORA-06512: at "SYS.DBMS_HS_UTL", line 431

      ORA-06512: at "SYS.DBMS_HS_CHK", line 66

      

      desc HS$_BASE_DD

      Name                Null?    Type

      ------------------- -------- -------------

      DD_TABLE_ID         NOT NULL NUMBER

      DD_TABLE_NAME       NOT NULL VARCHAR2(128)

      DD_TABLE_DESC                VARCHAR2(255)

      

      SELECT COUNT(*) FROM hs$_base_dd;

      

      COUNT(*)

      ----------

      102

      

      SELECT * FROM hs$_base_dd WHERE rownum < 11;

      

      DD_TABLE_ID DD_TABLE_NAME DD_TABLE_DESC

      ----------- --------------- ---------------

                1 DD_TKHODDTR1

                2 DD_TKHODDTR3

                3 DD_TKHODDTR5

                4 DD_TKHODDTR6

                5 DD_TKHODDTR7

                6 DD_TKHODDTR8

                7 DD_TKHODDTR9

                8 DD_TKHODDTR10

                9 ALL_CATALOG

               10 ALL_COL_COMMENT

      

      SELECT dbms_hs_chk.check_base_dd('ALL_CATALOG')

      FROM dual;

      

      DBMS_HS_CHK.CHECK_BASE_DD('ALL_CATALOG')

      ----------------------------------------

                                             9

CHECK_CLASS_CAPS

Undocumented dbms_hs_chk.check_class_caps( fds_class_name IN VARCHAR2, cap_number IN NUMBER) RETURN NUMBER;

TBD

CHECK_CLASS_DD

Undocumented dbms_hs_chk.check_class_dd( fds_class_name IN VARCHAR2, dd_table_name IN VARCHAR2) RETURN NUMBER;

TBD

CHECK_CLASS_INIT

Undocumented dbms_hs_chk.check_class_init( fds_class_name IN VARCHAR2, init_value_name IN VARCHAR2) RETURN NUMBER;

TBD

CHECK_FDS_CLASS

Undocumented dbms_hs_chk.check_fds_class(fds_class_name IN VARCHAR2) RETURN NUMBER;

TBD

CHECK_FDS_INST

Undocumented dbms_hs_chk.check_fds_inst( fds_inst_name IN VARCHAR2, fds_class_name IN VARCHAR2) RETURN NUMBER;

TBD

CHECK_INIT_VALUE_TYPE

Undocumented dbms_hs_chk.check_init_value_type(init_value_type IN VARCHAR2);

TBD

CHECK_INST_CAPS

Undocumented dbms_hs_chk.check_inst_caps( fds_inst_name IN VARCHAR2, fds_class_name IN VARCHAR2, cap_number IN NUMBER) RETURN NUMBER;

TBD

CHECK_INST_DD

Undocumented dbms_hs_chk.check_inst_dd( fds_inst_name IN VARCHAR2, fds_class_name IN VARCHAR2, dd_table_name IN VARCHAR2) RETURN NUMBER;

TBD

CHECK_INST_INIT

Undocumented dbms_hs_chk.check_inst_init( fds_inst_name IN VARCHAR2, fds_class_name IN VARCHAR2, init_value_name IN VARCHAR2) RETURN NUMBER;

TBD

CHECK_TRANSLATION_TEXT

Undocumented dbms_hs_chk.check_translation_text( translation_text IN VARCHAR2, translation_type IN VARCHAR2);

TBD

CHECK_TRANSLATION_TYPE

Undocumented dbms_hs_chk.check_translation_type(translation_type IN CHAR);

TBD