Tuesday, June 9, 2009

DBA_NETWORK_ACL_PRIVILEGES

DBA_NETWORK_ACL_PRIVILEGES describes the network privileges defined in all access control lists that are currently assigned to network hosts.

Column

Datatype

NULL

Description

ACL

VARCHAR2(4000)

Path of the access control list

ACLID

RAW(16)

NOT NULL

Object ID of the access control list

PRINCIPAL

VARCHAR2(4000)

Principal (database user or role) whom the privilege is granted to or denied from

PRIVILEGE

VARCHAR2(7)

Network privilege

IS_GRANT

VARCHAR2(5)

Indicates whether the privilege is granted (true) or denied (false)

INVERT

VARCHAR2(5)

Indicates whether the access control entry contains invert principal (true) or not (false)

START_DATE

TIMESTAMP(9) WITH TIME ZONE

Start date of the access control entry

END_DATE

TIMESTAMP(9) WITH TIME ZONE

End date of the access control entry

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

Thursday, May 28, 2009

SMTP_OUT_SERVER

Property

Description

Parameter type

String

Syntax

SMTP_OUT_SERVER = server_clause [, server_clause ] ...

server_clause::=

host_name[:port]

Default value

There is no default value.

Modifiable

No

SMTP_OUT_SERVER specifies the SMTP host and port to which UTL_MAIL delivers out-bound E-mail. Multiple servers may be specified, separated by commas.

If the first server in the list is unavailable, then UTL_MAIL tries the second server, and so on.

If SMTP_OUT_SERVER is not specified, then the SMTP server name defaults to the value of DB_DOMAIN, the port number defaults to 25, and the SMTP domain defaults to the suffix of DB_DOMAIN.

See Also: Oracle Database PL/SQL Packages and Types Reference for information on the UTL_MAIL package

Note:

1. The parameter was introduced in 10g.

Oracle initializatoin parameters

Friday, May 22, 2009

DBA_TRANSFORMATIONS

DBA_TRANSFORMATIONS displays information about all transformations in the database. These transformations can be specified with Advanced Queuing operations such as enqueue, dequeue, and subscribe to automatically integrate transformations in AQ messaging.

Related View

USER_TRANSFORMATIONS displays information about transformations owned by the current user. This view does not display the OWNER column.

Column

Datatype

NULL

Description

TRANSFORMATION_ID

NUMBER

NOT NULL

Unique identifier for the transformation

OWNER

VARCHAR2(30)

NOT NULL

Owning user of the transformation

NAME

VARCHAR2(30)

NOT NULL

Transformation name

FROM_TYPE

VARCHAR2(61)

Source type name

TO_TYPE

VARCHAR2(91)

Target type name

Oracle data dictionary views

Oracle dynamic performance views