Managing Fine-Grained Access in PL/SQL Packages and Types

Oracle Database provides PL/SQL packages and types for fine-grained access to control access to external network services and wallets.

• About Managing Fine-Grained Access in PL/SQL Packages and Types
  You can configure user access to external network services and wallets through a set of PL/SQL packages and one type.

• About Fine-Grained Access Control to External Network Services
  Oracle Application Security access control lists (ACL) can implement fine-grained access control to external network services.

• About Access Control to Oracle Wallets
  When accessing remote Web server-protected Web pages, users can authenticate themselves with passwords and client certificates stored in an Oracle wallet.

• Upgraded Applications That Depend on Packages That Use External Network Services
  Upgraded applications may have ORA-24247 network access errors.

• Configuring Access Control for External Network Services
  The DBMS_NETWORK_ACL packages configures access control for external network services.

• Configuring Access Control to an Oracle Wallet
  Fine-grained access control for Oracle wallets provide user access to network services that require passwords or certificates.

• Examples of Configuring Access Control for External Network Services
  You can configure access control for a variety of situations, such as for a single role and network connection.

• Specifying a Group of Network Host Computers
  You can use wildcards to specify a group of network host computers.

• Precedence Order for a Host Computer in Multiple Access Control List Assignments
  The access control list assigned to a domain has a lower precedence than those assigned to the subdomains.

• Precedence Order for a Host in Access Control List Assignments with Port Ranges
  The precedence order for a host in an access control list is determined by the use of port ranges.

• Checking Privilege Assignments That Affect User Access to Network Hosts
  Both administrators and users can check network connection and domain privileges.

• Configuring Network Access for Java Debug Wire Protocol Operations
  Before you can debug Java PL/SQL procedures, you must be granted the jdwp ACL privilege.

• Data Dictionary Views for Access Control Lists Configured for User Access
  Oracle Database provides data data dictionary views that you can use to find information about existing access control lists.