Oracle documentation really **** sometimes

From: Taylor, Chris David <Chris.Taylor_at_ingrambarge.com>
Date: Tue, 9 Jun 2009 16:33:35 -0500
Message-ID: <17E4CDE8F84DC44A992E8C00767402E0023C619D_at_spobmexc02.adprod.directory>

Ok, I ran into an issue with Apex "Password Complexity Rules" and went searching.  

FROM:

-------------------------------------------- <begin cut>
------------------------------------------

Oracle(r) Application Express Application Builder User's Guide Release 3.2
Part Number E11838-01  

13 Managing Application Security
...
...
Execute the following statement:  

ALTER SESSION SET CURRENT_SCHEMA = APEX_030200;   Execute the following statement:  

BEGIN
APEX_INSTANCE_ADMIN.SET_PARAMETER('PASSWORD_HISTORY_DAYS',365); COMMIT;
END;
/
 

This will restrict new or updated passwords to those that have not been used for the account for the previous 365 days. Recording of previously used passwords (actually, hashed representations of passwords) begins upon installation of Oracle Application Express 3.2.  

To disable this feature, run the block above, providing 0 for the parameter value. For example:  

BEGIN
APEX_INSTANCE_ADMIN.SET_PARAMETER('PASSWORD_HISTORY_DAYS',0); COMMIT;
END;
/

-------------------------------------------- <end cut>
------------------------------------------
 

Now, I decide to see what available parameters there are for this function:  

So I turn to the API guide:
Oracle(r) Application Express API Reference Release 3.2
Part Number E13369-01  

I find the function APEX_INSTANCE_ADMIN, and look at "AVAILABLE FUNCTIONS", and what do I find?  

10 functions  

SMTP_FROM
SMTP_HOST_ADDRESS
SMTP_HOST_PORT

WALLET_PATH
WALLET_PWD

PRINT_BIB_LICENSED
PRINT_SVR_PROTOCOL
PRINT_SVR_HOST
PRINT_SVR_PORT
PRINT_SVR_SCRIPT
 

Nothing about Password Complexity settings - including the one parameter I KNOW exists!  

So, does ANYONE know the full list of parameters that can be adjusted using APEX_INSTANCE_ADMIN, or perhaps APEX_UTIL??  

(Yes, I am in a bad mood)  

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor_at_ingrambarge.com
<mailto:chris.taylor_at_ingrambarge.com>  

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.    

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 09 2009 - 16:33:35 CDT