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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_HS_ALT
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