APEX Instance Admin Preferences Cheat Sheet
APEX comes with an API - APEX_INSTANCE_ADMIN - where you can both get and set instance preferences. There is a list of available properties on the documentation, however I found that not all preferences were documented there. For example, in Feature Configuration, there are some preferences surrounding packaged applications:
Looking at the documentation, https://docs.oracle.com/cd/E59726_01/doc.50/e39149/apex_instance.htm#CHDFEICJ, you may find it difficult locating these.
Then, there other properties in there that I don't think are relevant any more (..but not an expert on the subject, so may be wrong). Lets take the example of PASSWORD_HISTORY_DAYS - this states "Defines the maximum number of days a developer or administrator account password may be used before the account expires. The default value is 45 days.". We can locate the property it's talking about under Security - Authentication Control - Development Environment Settings.
If we attempt to query this property name, you will find nothing is returned.
Digging into this, it looks to me this relates to the parameter ACCOUNT_LIFETIME_DAYS.
So anyway, with all this said, here is what I've come up with a table mapping each field to a parameter name - some on the docs, others not.
Text Version:
Feature Configuration
Instance Settings
Workspace Purge Settings:
Looking at the documentation, https://docs.oracle.com/cd/E59726_01/doc.50/e39149/apex_instance.htm#CHDFEICJ, you may find it difficult locating these.
Then, there other properties in there that I don't think are relevant any more (..but not an expert on the subject, so may be wrong). Lets take the example of PASSWORD_HISTORY_DAYS - this states "Defines the maximum number of days a developer or administrator account password may be used before the account expires. The default value is 45 days.". We can locate the property it's talking about under Security - Authentication Control - Development Environment Settings.
If we attempt to query this property name, you will find nothing is returned.
Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production SQL> set serveroutput on SQL> begin 2 dbms_output.put_line('Value: ' || apex_instance_admin.get_parameter('PASSWORD_HISTORY_DAYS')); 3 end; 4 / Value: PL/SQL procedure successfully completed. SQL>
Digging into this, it looks to me this relates to the parameter ACCOUNT_LIFETIME_DAYS.
So anyway, with all this said, here is what I've come up with a table mapping each field to a parameter name - some on the docs, others not.
Text Version:
Feature Configuration
Application Development | Parameter Name |
Allow PL/SQL Program Unit Editing | PLSQL_EDITING |
Create demonstration objects in new workspaces | WORKSPACE_PROVISION_DEMO_OBJECTS |
Create websheet objects in new workspaces | WORKSPACE_WEBSHEET_OBJECTS |
Enable SQL Access in Websheets | WEBSHEET_SQL_ACCESS |
Packaged Application install Options | |
Allow HTTP Header Variable authentication | PKG_APP_AUTH_ALLOW_HHEAD |
Allow LDAP Directory authentication | PKG_APP_AUTH_ALLOW_LDAP |
Allow Oracle Applicaion Server Single Sign-On authentication | PKG_APP_AUTH_ALLOW_SSO |
SQL Workshop | |
SQL Commands Maximum Inactivity in minutes | SQL_COMMAND_MAX_INACTIVITY |
SQL Scripts Maximum Script Output Size in bytes | SQL_SCRIPT_MAX_OUTPUT_SIZE |
SQL Scripts Maximum Workspace Output Size in bytes | WORKSPACE_MAX_OUTPUT_SIZE |
SQL Script Maximum Script Size in bytes | MAX_SCRIPT_SIZE |
Enable transactional SQL Commands | ENABLE_TRANSACTIONAL_SQL |
Enable RESTful Services | RESTFUL_SERVICES_ENABLED |
Monitoring | |
Enable Database Monitoring | ALLOW_DB_MONITOR |
Application Activity Logging | APPLICATION_ACTIVITY_LOGGING |
Enable Application Tracing | TRACING_ENABLED |
Workspace Administration | |
Enable Service Requests | SERVICE_REQUESTS_ENABLED |
Team Development | |
Enable Team Developer's File Repository | WORKSPACE_TEAM_DEV_FILES_YN |
Maximum File Size (in MB) | WORKSPACE_TEAM_DEV_FS_LIMIT |
Security
Security | Parameter Name |
Set Workspace Cookie | WORKSPACE_NAME_USER_COOKIE |
Disable Adminstrator Login | DISABLE_ADMIN_LOGIN |
Disable Workspace login | DISABLE_WORKSPACE_LOGIN |
Allow Public File Upload | ALLOW_PUBLIC_FILE_UPLOAD |
Restrict Access by IP Address | RESTRICT_IP_RANGE |
Instance Proxy | INSTANCE_PROXY |
Checksum Hash Function | CHECKSUM_HASH_FUNCTION |
Rejoin Sessions | REJOIN_EXISTING_SESSIONS |
Unhandled Errors | HTTP_ERROR_STATUS_ON_ERROR_PAGE_ENABLED |
HTTP Protocol | |
Require HTTPS | REQUIRE_HTTPS |
Require Outbound HTTPS | REQUIRE_OUT_HTTPS |
HTTP Response Headers | HTTP_RESPONSE_HEADERS |
RESTful Access | |
Allow RESTful Access | ALLOW_REST |
Session Timeout | |
Maximum Session Length in Seconds | MAX_SESSION_LENGTH_SEC |
Maximum Session Idle Time in Seconds | MAX_SESSION_IDLE_SEC |
Workspace Isolation | |
Allow Hostnames | ALLOW_HOSTNAMES |
Resource Consumer Group | RM_CONSUMER_GROUP |
Maximum Concurrent Workspace Requests | QOS_MAX_WORKSPACE_REQUESTS |
Maximum Concurrent Session Requests | QOS_MAX_SESSION_REQUESTS |
Concurrent Session Requests Kill Timeout | QOS_MAX_SESSION_KILL_TIMEOUT |
Maximum Size of FIles in Workspace | WORKSPACE_MAX_FILE_BYTES |
Region and Web Service Excluded Domains | |
Domain Must Not Contain | BAD_URLS |
Authentication Control | |
General Settings | |
Delay after failed login attempts in Seconds | LOGIN_THROTTLE_DELAY |
Method for computing the Delay | LOGIN_THROTTLE_METHODS |
Inbound Proxy Servers | INBOUND_PROXIES |
Single Sign-On Logout URL | SSO_LOGOUT_URL |
Development Environment Settings | |
Username validation expression | USERNAME_VALIDATION |
Require User Account Expiration and Locking | EXPIRE_FND_USER_ACCOUNTS |
Maximum Login Failures Allowed | MAX_LOGIN_FAILURES |
Account Password Lifetime (days) | ACCOUNT_LIFETIME_DAYS |
Current Workspace Authentication Schem | APEX_BUILDER_AUTHENTICATION |
Password Policy | |
Password Hash Function | PASSWORD_HASH_FUNCTION |
Minimum Password Length | PASSWORD_MIN_LENGTH |
Minimum Password Differences | PASSWORD_NEW_DIFFERS_BY |
Must Contain At Least One Alphabetic Character | PASSWORD_ONE_ALPHA |
Must Contain At Least One Numeric Character | PASSWORD_ONE_NUMERIC |
Must COntain At Least One Punctuation Character | PASSWORD_ONE_PUNCTUATION |
Must Contain At Least One Upper Case CHaracter | PASSWORD_ONE_UPPER_CASE |
Must Contain At Least One Lower Case Character | PASSWORD_ONE_LOWER_CASE |
Must Not Contain Username | PASSWORD_NOT_LIKE_USERNAME |
Must Not Contain Workspace Name | PASSWORD_NOT_LIKE_WS_NAME |
Must Not Contain | PASSWORD_NOT_LIKE_WORDS |
Alphabetic Characters | PASSWORD_ALPHA_CHARACTERS |
Punctuation Characters | PASSWORD_PUNCTUATION_CHARACTERS |
Service Administrator Poassword Policy | STRONG_SITE_ADMIN_PASSWORD |
Instance Settings
Self Service | Parameter Name |
Provisioning Status | SERVICE_REQUEST_FLOW |
Require Verification Code | REQUIRE_VERIFICATION_CODE |
Notification Email Address | NOTIFICATION_EMAIL |
Email Provisioning | |
Email Provisioning | DISABLE_WS_PROV |
Message | DISABLE_WS_MSG |
Storage | |
Require New Schema | REQ_NEW_SCHEMA |
Auto Extent Tablespaces | AUTOEXTEND_TABLESPACES |
Bigfile Tablespaces | BIGFILE_TABLESPACES_ENABLED |
Encrypted Tablespaces | ENCRYPTED_TABLESPACES_ENABLED |
Delete Uploaded Files After (days) | DELETE_UPLOADED_FILES_AFTER_DAYS |
Application Express Instance URL | EMAIL_INSTANCE_URL |
Application Express Images URL | EMAIL_IMAGES_URL |
SMTP Host Address | SMTP_HOST_ADDRESS |
SMTP Host Port | SMTP_HOST_PORT |
SMTP Authentication username | SMTP_USERNAME |
SMTP Authentication password | SMTP_PASSWORD |
Use SSL/TLS | SMTP_TLS_MODE |
Default Email From Address | SMTP_FROM |
Maximum Emails per Workspace | WORKSPACE_EMAIL_MAXIMUM |
Wallet | |
Wallet Path | WALLET_PATH |
Wallet Password | WALLET_PWD |
Report Printing | |
Print Server | PRINT_BIB_LICENSED |
Printer Server Protocol | PRINT_SVR_PROTOCOL |
Print Server Host Address | PRINT_SVR_HOST |
Print Server Port | PRINT_SVR_PORT |
Print Server Script | PRINT_SVR_SCRIPT |
Print Timeout | PRINT_SVR_TIMEOUT |
Help | |
Help URL | SYSTEM_HELP_URL |
Application ID Range | |
ID Minimum | APPLICATION_ID_MIN |
ID Maximum | APPLICATION_ID_MAX |
Workspace Purge Settings:
Workspace Purge Settings | Parameter Name |
Enabled | PURGE_ENABLED |
Language | PURGE_LANG |
Purge Adminsitration Email Address | PURGE_ADMIN_EMAIL |
Send Summary Email to | PURGE_SUMMARY_EMAIL_TO |
Days until purge | PURGE_DAYS_TO_PURGE |
Reminder days in advance | PURGE_REMINDER_DAYS_IN_ADVANCE |
Days inactive | PURGE_DAYS_INACTIVE |
Grace period (days) | PURGE_GRACE_PERIOD_DAYS |
Maximum execution time (hours) | PURGE_MAX_RUN_HOURS |
Maximum number of workspaces | PURGE_MAX_WORKSPACES |
Maximum number of emails | PURGE_MAX_EMAILS |
Image:
Feature Configuration:
Security:
Instance Settings:
Workspace purge settings: