Monday, 11 January 2016

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.

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 DevelopmentParameter Name
Allow PL/SQL Program Unit EditingPLSQL_EDITING
Create demonstration objects in new workspacesWORKSPACE_PROVISION_DEMO_OBJECTS
Create websheet objects in new workspacesWORKSPACE_WEBSHEET_OBJECTS
Enable SQL Access in WebsheetsWEBSHEET_SQL_ACCESS
Packaged Application install Options
Allow HTTP Header Variable authenticationPKG_APP_AUTH_ALLOW_HHEAD
Allow LDAP Directory authenticationPKG_APP_AUTH_ALLOW_LDAP
Allow Oracle Applicaion Server Single Sign-On authenticationPKG_APP_AUTH_ALLOW_SSO
SQL Workshop
SQL Commands Maximum Inactivity in minutesSQL_COMMAND_MAX_INACTIVITY
SQL Scripts Maximum Script Output Size in bytesSQL_SCRIPT_MAX_OUTPUT_SIZE
SQL Scripts Maximum Workspace Output Size in bytesWORKSPACE_MAX_OUTPUT_SIZE
SQL Script Maximum Script Size in bytesMAX_SCRIPT_SIZE
Enable transactional SQL CommandsENABLE_TRANSACTIONAL_SQL
Enable RESTful ServicesRESTFUL_SERVICES_ENABLED
Monitoring
Enable Database MonitoringALLOW_DB_MONITOR
Application Activity LoggingAPPLICATION_ACTIVITY_LOGGING
Enable Application TracingTRACING_ENABLED
Workspace Administration
Enable Service RequestsSERVICE_REQUESTS_ENABLED
Team Development
Enable Team Developer's File RepositoryWORKSPACE_TEAM_DEV_FILES_YN
Maximum File Size (in MB)WORKSPACE_TEAM_DEV_FS_LIMIT


Security

SecurityParameter Name
Set Workspace CookieWORKSPACE_NAME_USER_COOKIE
Disable Adminstrator LoginDISABLE_ADMIN_LOGIN
Disable Workspace loginDISABLE_WORKSPACE_LOGIN
Allow Public File UploadALLOW_PUBLIC_FILE_UPLOAD
Restrict Access by IP AddressRESTRICT_IP_RANGE
Instance ProxyINSTANCE_PROXY
Checksum Hash FunctionCHECKSUM_HASH_FUNCTION
Rejoin SessionsREJOIN_EXISTING_SESSIONS
Unhandled ErrorsHTTP_ERROR_STATUS_ON_ERROR_PAGE_ENABLED
HTTP Protocol
Require HTTPSREQUIRE_HTTPS
Require Outbound HTTPSREQUIRE_OUT_HTTPS
HTTP Response HeadersHTTP_RESPONSE_HEADERS
RESTful Access
Allow RESTful AccessALLOW_REST
Session Timeout
Maximum Session Length in SecondsMAX_SESSION_LENGTH_SEC
Maximum Session Idle Time in SecondsMAX_SESSION_IDLE_SEC
Workspace Isolation
Allow HostnamesALLOW_HOSTNAMES
Resource Consumer GroupRM_CONSUMER_GROUP
Maximum Concurrent Workspace RequestsQOS_MAX_WORKSPACE_REQUESTS
Maximum Concurrent Session RequestsQOS_MAX_SESSION_REQUESTS
Concurrent Session Requests Kill TimeoutQOS_MAX_SESSION_KILL_TIMEOUT
Maximum Size of FIles in WorkspaceWORKSPACE_MAX_FILE_BYTES
Region and Web Service Excluded Domains
Domain Must Not ContainBAD_URLS
Authentication Control
General Settings
Delay after failed login attempts in SecondsLOGIN_THROTTLE_DELAY
Method for computing the DelayLOGIN_THROTTLE_METHODS
Inbound Proxy ServersINBOUND_PROXIES
Single Sign-On Logout URLSSO_LOGOUT_URL
Development Environment Settings
Username validation expressionUSERNAME_VALIDATION
Require User Account Expiration and LockingEXPIRE_FND_USER_ACCOUNTS
Maximum Login Failures AllowedMAX_LOGIN_FAILURES
Account Password Lifetime (days)ACCOUNT_LIFETIME_DAYS
Current Workspace Authentication SchemAPEX_BUILDER_AUTHENTICATION
Password Policy
Password Hash FunctionPASSWORD_HASH_FUNCTION
Minimum Password LengthPASSWORD_MIN_LENGTH
Minimum Password DifferencesPASSWORD_NEW_DIFFERS_BY
Must Contain At Least One Alphabetic CharacterPASSWORD_ONE_ALPHA
Must Contain At Least One Numeric CharacterPASSWORD_ONE_NUMERIC
Must COntain At Least One Punctuation CharacterPASSWORD_ONE_PUNCTUATION
Must Contain At Least One Upper Case CHaracterPASSWORD_ONE_UPPER_CASE
Must Contain At Least One Lower Case CharacterPASSWORD_ONE_LOWER_CASE
Must Not Contain UsernamePASSWORD_NOT_LIKE_USERNAME
Must Not Contain Workspace NamePASSWORD_NOT_LIKE_WS_NAME
Must Not ContainPASSWORD_NOT_LIKE_WORDS
Alphabetic CharactersPASSWORD_ALPHA_CHARACTERS
Punctuation CharactersPASSWORD_PUNCTUATION_CHARACTERS
Service Administrator Poassword PolicySTRONG_SITE_ADMIN_PASSWORD

Instance Settings

Self ServiceParameter Name
Provisioning StatusSERVICE_REQUEST_FLOW
Require Verification CodeREQUIRE_VERIFICATION_CODE
Notification Email AddressNOTIFICATION_EMAIL
Email Provisioning
Email ProvisioningDISABLE_WS_PROV
MessageDISABLE_WS_MSG
Storage
Require New SchemaREQ_NEW_SCHEMA
Auto Extent TablespacesAUTOEXTEND_TABLESPACES
Bigfile TablespacesBIGFILE_TABLESPACES_ENABLED
Encrypted TablespacesENCRYPTED_TABLESPACES_ENABLED
Delete Uploaded Files After (days)DELETE_UPLOADED_FILES_AFTER_DAYS
Email
Application Express Instance URLEMAIL_INSTANCE_URL
Application Express Images URLEMAIL_IMAGES_URL
SMTP Host AddressSMTP_HOST_ADDRESS
SMTP Host PortSMTP_HOST_PORT
SMTP Authentication usernameSMTP_USERNAME
SMTP Authentication passwordSMTP_PASSWORD
Use SSL/TLSSMTP_TLS_MODE
Default Email From AddressSMTP_FROM
Maximum Emails per WorkspaceWORKSPACE_EMAIL_MAXIMUM
Wallet
Wallet PathWALLET_PATH
Wallet PasswordWALLET_PWD
Report Printing
Print ServerPRINT_BIB_LICENSED
Printer Server ProtocolPRINT_SVR_PROTOCOL
Print Server Host AddressPRINT_SVR_HOST
Print Server PortPRINT_SVR_PORT
Print Server ScriptPRINT_SVR_SCRIPT
Print TimeoutPRINT_SVR_TIMEOUT
Help
Help URLSYSTEM_HELP_URL
Application ID Range
ID MinimumAPPLICATION_ID_MIN
ID MaximumAPPLICATION_ID_MAX

Workspace Purge Settings:

Workspace Purge SettingsParameter Name
EnabledPURGE_ENABLED
LanguagePURGE_LANG
Purge Adminsitration Email AddressPURGE_ADMIN_EMAIL
Send Summary Email toPURGE_SUMMARY_EMAIL_TO
Days until purgePURGE_DAYS_TO_PURGE
Reminder days in advancePURGE_REMINDER_DAYS_IN_ADVANCE
Days inactivePURGE_DAYS_INACTIVE
Grace period (days)PURGE_GRACE_PERIOD_DAYS
Maximum execution time (hours)PURGE_MAX_RUN_HOURS
Maximum number of workspacesPURGE_MAX_WORKSPACES
Maximum number of emailsPURGE_MAX_EMAILS

Image:

Feature Configuration:


Security:




Instance Settings:













































































Workspace purge settings:







1 comment: