Evaluate the following block of code
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
acl => lmycompany-com-permissions.xmll1
principal => ‘ACCTJvlGR1,
is_grant => TRUE,
privilege => ‘connect’);
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
acl => ‘mycompany-com-permissions.xml’,
host => “.mycompany.com’);
END;
What is the outcome of the above code?
A.
It produces an error because a fully qualified host name needs to be specified.
B.
It produces an error because the range of ports associated with the hosts has not been
specified.
C.
It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and
RESOLVE privileges
D.
It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT
privilege but not the RESOLVE privilege.