7.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 can connect 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 users can 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 your database through PL/SQL network utility packages such as UTL_TCP.
Answer: B

参考：http://docs.oracle.com/cd/E11882_01/network.112/e36292/authorization.htm#DBSEG99983

DBMS_NETWORK_ACL_ADMIN包提供了管理网络访问控制列表（ACL）的接口。

SQL> desc DBMS_NETWORK_ACL_ADMIN ;
PROCEDURE ADD_PRIVILEGE
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
ACL                            VARCHAR2                IN
PRINCIPAL                      VARCHAR2                IN
IS_GRANT                       BOOLEAN                 IN
PRIVILEGE                      VARCHAR2                IN
POSITION                       BINARY_INTEGER          IN     DEFAULT
START_DATE                     TIMESTAMP WITH TIME ZONE IN     DEFAULT
END_DATE                       TIMESTAMP WITH TIME ZONE IN     DEFAULT
PROCEDURE ASSIGN_ACL
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
ACL                            VARCHAR2                IN
HOST                           VARCHAR2                IN
LOWER_PORT                     BINARY_INTEGER          IN     DEFAULT
UPPER_PORT                     BINARY_INTEGER          IN     DEFAULT
PROCEDURE ASSIGN_WALLET_ACL
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
ACL                            VARCHAR2                IN
WALLET_PATH                    VARCHAR2                IN
FUNCTION CHECK_PRIVILEGE RETURNS NUMBER
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
ACL                            VARCHAR2                IN
USER                           VARCHAR2                IN
PRIVILEGE                      VARCHAR2                IN
FUNCTION CHECK_PRIVILEGE_ACLID RETURNS NUMBER
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
ACLID                          RAW                     IN
USER                           VARCHAR2                IN
PRIVILEGE                      VARCHAR2                IN
PROCEDURE CREATE_ACL
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
ACL                            VARCHAR2                IN
DESCRIPTION                    VARCHAR2                IN
PRINCIPAL                      VARCHAR2                IN
IS_GRANT                       BOOLEAN                 IN
PRIVILEGE                      VARCHAR2                IN
START_DATE                     TIMESTAMP WITH TIME ZONE IN     DEFAULT
END_DATE                       TIMESTAMP WITH TIME ZONE IN     DEFAULT
PROCEDURE DELETE_PRIVILEGE
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
ACL                            VARCHAR2                IN
PRINCIPAL                      VARCHAR2                IN
IS_GRANT                       BOOLEAN                 IN     DEFAULT
PRIVILEGE                      VARCHAR2                IN     DEFAULT
PROCEDURE DROP_ACL
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
ACL                            VARCHAR2                IN
PROCEDURE HANDLEPREDELETE
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
EVENT                          RAW(32)                 IN
PROCEDURE UNASSIGN_ACL
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
ACL                            VARCHAR2                IN     DEFAULT
HOST                           VARCHAR2                IN     DEFAULT
LOWER_PORT                     BINARY_INTEGER          IN     DEFAULT
UPPER_PORT                     BINARY_INTEGER          IN     DEFAULT
PROCEDURE UNASSIGN_WALLET_ACL
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
ACL                            VARCHAR2                IN     DEFAULT
WALLET_PATH                    VARCHAR2                IN     DEFAULT

ITPub博客

1Z0-053 V13.02 Q7

最新文章