Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

11 Web-centric Security in APEX > Securing an APEX Instance

Securing an APEX Instance

In this section, you’ll learn a few techniques to secure each component in the APEX architecture, including the Oracle Database and OHS. The code and metadata for APEX are installed in a database schema with high-level privileges such as ALTER SYSTEM and ALTER USER, thus making APEX_ XXXXXX or FLOWS_XXXXXX schemas a prime target for someone wishing to gain unauthorized access to the database. The front end of APEX is served through OAS or OHS and is often exposed to the Internet, which typically means that a much greater population has access to this tier.

APEX Security Settings

Within the APEX administration interface is a whole section dedicated to security settings. To view or modify these settings, you must have administrator credentials for APEX as whole, not just for a workspace. To access the administration interface, navigate to http://servername:port/pls/apex/apex_admin. If you are using the Embedded PL/SQL Gateway, you can omit /pls from the URL. If this is a new install, the username is admin and the password must be set using the script apxchpwd.sql found in the APEX installation directory. This script is also used to reset the admin password should it be lost. It’s a good practice to create administrator accounts for the people who need them instead of everyone logging in using admin, which provides no accountability. After you are logged into the administrative interface, open the Manage Service tab, shown in Figure 11-4, and click Security in the Manage Environment Settings area.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint