TRUSTED_SERVERS
TRUSTED_SERVERS displays whether a server is trusted or untrusted.
Note: Enterprise User Security (EUS) is deprecated with Oracle AI Database 26ai.
Oracle recommends that you migrate to using Centrally Managed Users (CMU). This feature enables you to directly connect with Microsoft Active Directory without an intervening directory service for enterprise user authentication and authorization to the database. If your Oracle Database is in the cloud, you can also choose to move to one of the newer integrations with a cloud identity provider.
| Column | Datatype | NULL | Description |
|---|---|---|---|
TRUST |
VARCHAR2(9) |
Trustedness of the server listed. Values can be TRUSTED or UNTRUSTED servers which are not listed in the NAME column have opposite trustedness. |
|
NAME |
VARCHAR2(128) |
Server name. Can be a specific server name or ALL for all servers. |
Table 7-2 shows examples of the values returned depending on the status of the servers.
Table 7-2 TRUSTED_SERVERS Values
| Condition (If . . . ) | TRUSTED column | NAME column |
|---|---|---|
| … all servers are trusted | Trusted |
ALL |
| … no servers are trusted | Untrusted |
ALL |
| … all servers except DB1 are trusted | Untrusted |
DB1 |
| … all servers except DB1 are untrusted | Trusted |
DB1 |