| General Information |
| Purpose |
Used to verify HTMLDB system state |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmshtdb.sql |
| First Available |
9.2.0.1 |
| 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 |
| Exceptions |
| Number |
Description |
| ORA-600 |
internal_error_errcode |
| ORA-28000 |
account_locked_errcode |
| ORA-28001 |
password_expired_errcode |
| ORA-32058 |
invalid_caller_errcode |
|
| Security Model |
Owned by SYS with no granted privileges |
| |
| VERIFY_USER |
Verifies that the username and password pair is valid
Or at least it would if it worked the way one might assume it does |
htmldb_system.verify_user(
username IN VARCHAR2 CHARACTER SET ANY_CS,
password IN VARCHAR2 CHARACTER SET ANY_CS)
RETURN PLS_INTEGER; |
SQL> conn / as sysdba
Connected.
SQL> SELECT htmldb_system.verify_user('UWCLASS', 'UWCLASS')
2 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 |
