D
DBMS_DISTRIBUTED_TRUST_ADMIN Package Reference

This appendix describes the procedures and functions in the package DBMS_DISTRIBUTED_TRUST_ADMIN for administering the Trusted Servers List. See Trusting Other Databasesfor more information.

Note that the data dictionary view TRUSTED_SERVERS can be used to see which databases are (not) trusted by the database.

Referenced in this appendix are:

• DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_ ALL
• DBMS_DISTRIBUTED_TRUST_ADMIN.ALLOW_ ALL
• DBMS_DISTRIBUTED_TRUST_ADMIN.ALLOW_SERVER (SERVER IN VARCHAR2)
• DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_SERVER (SERVER IN VARCHAR2)

DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_ ALL

Purpose

DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_ALL empties the Trusted Database List, and inserts an entry that specifies that all servers are untrusted. The view TRUSTED_SERVERS will show "UNTRUSTED ALL" indicating that no servers are currently trusted. Specific servers can then be allowed access using DBMS_DISTRIBUTED_TRUST_ADMIN.ALLOW_SERVER.

Interface Description

PROCEDURE deny_all

Parameters and Descriptions

Parameter	Description
None

Exceptions

Exception	Description
None

Purity Level

Purity level defined : None

See Also

DBMS_DISTRIBUTED_TRUST_ADMIN.ALLOW_ALL

DBMS_DISTRIBUTED_TRUST_ADMIN.ALLOW_ ALL

Purpose

DBMS_DISTRIBUTED_TRUST_ADMIN.ALLOW_ALL empties the Trusted Database List, and specifies that all servers trusted by the central authority, such as Oracle Security Server, are allowed access.

The view TRUSTED_SERVERS will show "TRUSTED ALL" indicating that all servers are currently trusted by the central authority, such as Oracle Security Server.

Specific servers can be made untrusted by using DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_SERVER

Interface Description

PROCEDURE allow_all

Parameters and Descriptions

Parameter	Description
None

Exceptions

Exception	Description
None

Purity Level

Purity level defined : None

See Also

DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_ALL

DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_SERVER

DBMS_DISTRIBUTED_TRUST_ADMIN.ALLOW_SERVER
(SERVER IN VARCHAR2)

Purpose

Ensures that the specified server is considered trusted (even if you have previously specified "deny all").

If the Trusted Servers List contains the entry "deny all", this procedure adds a specification indicating that a specific database (say DBx) is to be trusted.

If the Trusted Servers List contains the entry "allow all", and there is no "deny DBx" entry in the list, executing this procedure will cause no change.

If the Trusted Servers List contains the entry "allow all", and there is a "deny DBx" entry in the list, that entry will be deleted.

Interface Description

PROCEDURE allow_server(server IN VARCHAR2) SERVER_NAME

Parameter	Description
SERVER	The unique, fully-qualified name of the Server to be trusted

Parameters and Descriptions

Exceptions

Exception	Description
None

Purity Level

Purity Level defined: None

DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_SERVER
(SERVER IN VARCHAR2)

Purpose

Ensures that the specified server is considered untrusted (even if you have previously specified "allow all").

If the Trusted Servers List contains the entry "allow all", this procedure adds an entry indicating that the specified database (say DBx) is not to be trusted.

If the Trusted Servers List contains the entry "deny all", and there is no "allow DBx" entry in the list, this procedure causes no change.

If the Trusted Servers List contains the entry "deny all", and there is an "allow DBx" entry, this procedure will cause that entry to be deleted.

Interface Description

PROCEDURE deny_server(server IN VARCHAR2)

Parameter	Description
SERVER	The unique, fully-qualified name of the Server to be untrusted

Parameters and Descriptions

Exceptions

Exception	Description
None

Purity Level

Purity Level defined: None

---