Oracle documentation really **** sometimes
- From: "Taylor, Chris David" <Chris.Taylor@xxxxxxxxxxxxxxx>
- To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 9 Jun 2009 16:33:35 -0500
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@xxxxxxxxxxxxxxx
<mailto:chris.taylor@xxxxxxxxxxxxxxx>
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.
Other related posts:
- » Oracle documentation really **** sometimes - Taylor, Chris David
