You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the
DBMS_NETWORK_ACL_ADMIN package.
Which statement is true regarding the ACL created?
A
It is a list of remote database links stored in the XML file that are available to the users of the database.
B
It is a list of users and network privileges stored in the XML file according to which a group of users canconnect to one or more hosts.
C
It is a list of users and network privileges stored in the data dictionary according to which a group of userscan connect to one or more hosts.
D
It is the list of the host names or the IP addresses stored in the data dictionary that can connect to yourdatabase through PL/SQL network utility packages such
Correct Answer:
B
The DBMS_NETWORK_ACL_ADMIN package provides the interface to administer the network Access ControlList (ACL).
Refer to here for About Fin-Grained Access to External Network ServicesConfiguring fine-grained access control for users and roles that need to access external network services fromthe database. This way, specific groups of users can connect to one or more host computers, based onprivileges that you grant them.
Typically, you use this feature to control access to applications that run onspecific host addresses.
To configure fine-grained access control to external network services, you create an access control list (ACL),which is stored in Oracle XML DB. You can create the access control list by using Oracle XML DB itself, orby using the DBMS_NETWORK_ACL_ADMIN and DBMS_NETWORK_ACL_UTILITY PL/SQL packages.
This guideexplains how to use these packages to create and manage the access control list. To create an access controllist by using Oracle XML DB and for general conceptual information about access control lists, see Oracle XMLDB Developer's Guide.
Show Answer
