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 of 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