Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_DISTRIBUTED_TRUST_ADMIN , 5 of 5
This procedure ensures that the specified server is considered untrusted (even if you have previously specified "allow all").
DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_SERVER ( server IN VARCHAR2);
Parameter | Description |
---|---|
server |
Unique, fully-qualified name of the server to be untrusted. |
If the Trusted Servers List contains the entry "allow
all
", then this procedure adds an entry indicating that the specified database (for example, DBx
) is not to be trusted.
If the Trusted Servers List contains the entry "deny
all
", and if there is no "allow
DBx
" entry in the list, then this procedure causes no change.
If the Trusted Servers List contains the entry "deny
all
", and if there is an "allow
DBx
" entry, then this procedure causes that entry to be deleted.
If you have not yet used the package DBMS_DISTRIBUTED_TRUST_ADMIN
to change the trust listing, by default you trust all databases in the same enterprise domain if that domain it listed as trusted in the directory service:
SELECT * FROM TRUSTED_SERVERS; TRUST NAME --------- --------------------- Trusted All 1 row selected.
Because all servers are currently trusted, you can execute the DENY_SERVER
procedure and specify that a particular server is not trusted:
EXECUTE DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_SERVER ('SALES.US.AMERICAS.ACME_AUTO.COM'); Statement processed. SELECT * FROM TRUSTED_SERVERS; TRUST NAME --------- ----------------------------------------------- Untrusted SALES.US.AMERICAS.ACME_AUTO.COM 1 row selected
By executing the DENY_ALL
procedure, you can choose to not trust any database server:
EXECUTE DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_ALL; Statement processed. SELECT * FROM TRUSTED_SERVERS; TRUST NAME --------- ----------------------------------------------- Untrusted All 1 row selected.
The ALLOW_SERVER
procedure can be used to specify that one particular database is to be trusted:
EXECUTE DBMS_DISTRIBUTED_TRUST_ADMIN.ALLOW_SERVER ('SALES.US.AMERICAS.ACME_AUTO.COM'); Statement processed. SELECT * FROM TRUSTED_SERVERS; TRUST NAME --------- ------------------------------------------------ Trusted SALES.US.AMERICAS.ACME_AUTO.COM 1 row selected.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|