17.00 - ConnectRulesV - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

Category: Security

Database: DBC

View Column Data Type Format Comment
TrustUser VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the permanent user that has been granted the CONNECT THROUGH privilege.
ProxyUser VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the proxy user.
ProxyUserType VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) Returns one of the following proxy user types: P - A Teradata permanent user, A - An application user.
GrantStatus CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) Indicates whether the rule grants the CONNECT THROUGH privilege (G), or whether it has been revoked (R).
WithoutRole CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) Rule created with: Y (Without Role clause), N (Roles specified)
ProxyRole1 VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the role that can be set for the proxy user in a proxy connection.
ProxyRole2 VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ConnectRulesV.ProxyRole2 field shows the name of a role granted to the proxy user.
ProxyRole3 VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ConnectRulesV.ProxyRole3 field shows the name of a role granted to the proxy user.
ProxyRole4 VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ConnectRulesV.ProxyRole4 field shows the name of a role granted to the proxy user.
ProxyRole5 VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ConnectRulesV.ProxyRole5 field shows the name of a role granted to the proxy user.
ProxyRole6 VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ConnectRulesV.ProxyRole6 field shows the name of a role granted to the proxy user.
ProxyRole7 VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ConnectRulesV.ProxyRole7 field shows the name of a role granted to the proxy user.
ProxyRole8 VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ConnectRulesV.ProxyRole8 field shows the name of a role granted to the proxy user.
ProxyRole9 VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ConnectRulesV.ProxyRole9 field shows the name of a role granted to the proxy user.
ProxyRole10 VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ConnectRulesV.ProxyRole10 field shows the name of a role granted to the proxy user.
ProxyRole11 VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ConnectRulesV.ProxyRole11 field shows the name of a role granted to the proxy user.
ProxyRole12 VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ConnectRulesV.ProxyRole12 field shows the name of a role granted to the proxy user.
ProxyRole13 VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ConnectRulesV.ProxyRole13 field shows the name of a role granted to the proxy user.
ProxyRole14 VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ConnectRulesV.ProxyRole14 field shows the name of a role granted to the proxy user.
ProxyRole15 VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ConnectRulesV.ProxyRole15 field shows the name of a role granted to the proxy user.
CreatorName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Rule creator.
CreateTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the date and time that the object in the row was created.
TrustOnly CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) Indicates whether the ProxyUser must be set in a Trusted request.
ProfileName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the ProfileName associated with the application ProxyUser.