ConnectRulesV - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
prb1610499325399.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.