Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN
package? (Choose all that apply.)
A.
It can be used to allow the access privilege settings for users but not roles.
B.
It can be used to allow the access privilege settings for users as well as roles.
C.
It can be used to control the time interval for which the access privilege is available to a
user.
D.
It can be used to selectively restrict the access for each user in a database to different
host computers.
E.
It can be used to selectively restrict a user’s access to different applications in a specific
host computer.
B, C and D are correct:
https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_networkacl_adm.htm
B:
Principal (database user or role) to whom the privilege is granted or denied. Case sensitive.
C:
start_date
Start date of the access control entry (ACE). When specified, the ACE will be valid only on and after the specified date. The start_date will be ignored if the privilege is added to an existing ACE.
end_state
End date of the access control entry (ACE). When specified, the ACE will expire after the specified date. The end_date must be greater than or equal to the start_date. The end_date will be ignored if the privilege is added to an existing ACE.
D:
host
Host to which the ACL will be assigned. The host can be the name or the IP address of the host. A wildcard can be used to specify a domain or a IP subnet. The host or domain name is case-insensitive.