15.10 - ConnectRulesV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Security

DBC

 

View Column

Data Type

Format

Source Table.Column

TrustUser

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName (UPI, NUSI)

ProxyUser

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

ConnectRulesTbl.ProxyUser (Composite UPI)

ProxyUserType

VARCHAR(1)

UNICODE

X(1)

ConnectRulesTbl.ProxyUserId (Composite NUSI)

GrantStatus

CHAR(1) LATIN

NOT NULL

X(1)

ConnectRulesTbl.GrantStatus (Composite NUSI)

WithoutRole

CHAR(1) LATIN

NOT NULL

X(1)

ConnectRulesTbl.WithoutRole

ProxyRole1 through ProxyRole15

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

ConnectRulesTbl.ProxyRole1 through ConnectRulesTbl.ProxyRole15

CreatorName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

CreateTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ConnectRulesTbl.CreateTimeStamp

TrustOnly

CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1)

ConnectRulesTbl.TrustOnly

ProfileName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

ConnectRulesTbl.ProfileName

Example  

The following select statement returns the connect through privileges for all proxy users:

SELECT TrustUser (FORMAT 'X(20)'), ProxyUser (FORMAT 'X(20)'),
 ProxyUserType FROM DBC.ConnectRulesV order by 2;

 

Result:

TrustUser             ProxyUser             ProxyUserType
--------------------  --------------------  -------------
trustuser1            APPPXYUSER1           A
trustuser1            APPPXYUSER2           A
trustuser1            APPPXYUSER3           A
trustuser1            APPPXYUSER4           A
trustuser1            PXYUSER1              P
trustuser1            PXYUSER2              P
trustuser1            PXYUSER3              P
trustuser1            PXYUSER4              P

Example  

The following select statement returns the connect through privilege for a specified proxy user including the granted roles:

SELECT * FROM DBC.ConnectRulesV WHERE ProxyUser='PxyUser3';