Oracle HTMLDB_SYSTEM
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Purpose Used to verify HTMLDB system state
AUTHID CURRENT_USER
Constants
Name Data Type Value
invalid_user PLS_INTEGER 1
null_input PLS_INTEGER -1
valid_user PLS_INTEGER 0
Dependencies
WWV_FLOW_VAL_LIB    
Documented No
Exceptions
Error Code Reason
ORA-00600 internal_error
ORA-28000 account_locked_errcode
ORA-28001 password_expired_errcode
ORA-32058 invalid_caller_errcode
First Available 9.2.0.1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/dbmshtdb.sql
 
VERIFY_USER
Verifies that the username and password pair is valid

Can only be called by the user HTMLDB_USER which no longer exists in the database and, from the exception it appears that the user HTMLDB_USER must also be granted SYSDBA ... not going to happen.
htmldb_system.verify_user(
username IN VARCHAR2 CHARACTER SET ANY_CS,
password IN VARCHAR2 CHARACTER SET ANY_CS)
RETURN PLS_INTEGER;
conn sys@pdbdev as sysdba

SELECT htmldb_system.verify_user('UWCLASS', 'UWCLASS')
FROM dual;
SELECT htmldb_system.verify_user('UWCLASS', 'UWCLASS')
*
ERROR at line 1:
ORA-32058: operation restricted to SYSDBA users
ORA-06512: at "SYS.HTMLDB_SYSTEM", line 29
ORA-32058: operation restricted to SYSDBA users

Related Topics
Packages
WWV_FLOW_VAL

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-2014 Daniel A. Morgan All Rights Reserved