This Teradata QueryGrid connector Data Dictionary view provides details about the foreign servers defined in the system.
Possible Values for AuthorizationType
| Value | Description |
|---|---|
| T | Invoker Trusted |
| S | Definer Trusted |
| ' ' | Unknown |
Example: ServerV[X]
The following SELECT statement returns information about the foreign server objects created by user 'dba'.
select * from DBC.ServerV where CreatorName = 'dba';
Result:
ServerID 000011960000 DataBaseName TD_SERVER_DB ServerName SERVER_1 CreatorName dba CreateTimeStamp 2014-12-02 19:51:46 LastAlterName dba LastAlterTimeStamp 2014-12-02 19:51:46 ServerID 000012960000 DataBaseName TD_SERVER_DB ServerName SERVER_2 CreatorName dba CreateTimeStamp 2014-12-02 19:51:50 LastAlterName dba LastAlterTimeStamp 2014-12-02 19:51:50 AuthorizationName user1 AuthorizationType INVOKER TRUSTED