QUESTION NO: 384
Evaluate the following block of code:
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL
( acl => ‘mycompany-com-permissions.xml’,
principal => ‘ACCT_MGR’,
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.
Answer: C
评估下面的代码块:
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL
( acl => ‘mycompany-com-permissions.xml’,
principal => ‘ACCT_MGR’,
is_grant => TRUE, privilege => ‘connect’);
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL
( acl => ‘mycompany-com-permissions.xml’,
host => ‘*.mycompany.com’);
END;
上面的代码的结果是什么?
C.它创建一个拥有连接和分配权限的ACCT MGR用户的访问控制列表( ACL)。