OCP 1Z0 053 220

220.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. 
Answer: BCD

http://docs.oracle.com/cd/E11882_01/network.112/e36292/authorization.htm#DBSEG99984

Use the  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL  procedure to create the content of the access control list. It contains a name of the access control list, a brief description, and privilege settings for one user or role that you want to associate with the access control list. In an access control list, privileges for each user or role are grouped together as an access control entry (ACE). An access control list must have the privilege settings for at least one user or role.

.....

• start_date: (Optional) Enter the start date for the access control entry (ACE), in TIMESTAMP WITH TIME ZONE format (YYYY-MM-DD HH:MI:SS.FF TZR). When specified, the access control entry will be valid only on or after the specified date. The default is null. For example, to set a start date of February 28, 2008, at 6:30 a.m. in San Francisco, California, U.S., which is in the Pacific time zone:

  start_date => '2008-02-28 06:30:00.00 US/Pacific',
  

  The NLS_TIMESTAMP_FORMAT initialization parameter sets the default timestamp format. See Oracle Database Reference for more information.

• end_date: (Optional) Enter the end date for the access control entry (ACE), in TIMESTAMP WITH TIME ZONE format (YYYY-MM-DD HH:MI:SS.FF TZR). When specified, the access control entry expires after the specified date. The end_date setting must be greater than or equal to the start_date setting. The default is null.

  For example, to set an end date of December 10, 2008, at 11:59 p.m. in San Francisco, California, U.S., which is in the Pacific time zone:

  end_date => '2008-12-10 23:59:00.00 US/Pacific');