Oracle8 Distributed Database Systems Release 8.0 A58247-01 |
Library | Product | Contents | Index

# 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 Databases for 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

Prev | Next
| Copyright © 1997 Oracle Corporation. All Rights Reserved. |
Library | Product | Contents | Index