Tuesday, June 9, 2009

DBA_NETWORK_ACLS

 Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

====================================================================



DBA_NETWORK_ACLS describes the access control list assignments to network hosts.
Column
Datatype
NULL
Description
HOST
VARCHAR2(1000)
NOT NULL
Network host
LOWER_PORT
NUMBER(5)
Lower bound of the port range
UPPER_PORT
NUMBER(5)
Upper bound of the port range
ACL
VARCHAR2(4000)
Path of the access control list
ACLID
RAW(16)
NOT NULL
Object ID of the access control list
Note:
1. There are two data dictionary views related to ACL: DBA_NETWORK_ACLS and DBA_NETWORK_ACL_PRIVILEGES. ACLs are stored in XML DB, which must be installed for the use of ACLs. Two steps are needed to create ACL. The first step is to create the actual ACL and define privileges for it:
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
acl => ’file_name.xml’,
description => ’file description’,
principal => ’user_or_role’,
is_grant => TRUE|FALSE,
privilege => ’connect|resolve’,
start_date => null|timestamp_with_time_zone,
end_date => null|timestamp_with_time_zone);
END;
The second step is to assign network hosts to the ACL:
BEGIN
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
acl => ’file_name.xml’,
host => ’network_host’,
lower_port => null|port_number,
upper_port => null|port_number);
END;

Oracle data dictionary views

Oracle dynamic performance views