Teradata Data Dictionary-Frequently Used SQL (1 of 2)

DBC is superuser in Teradata. Very often we need to know some information from Data dictionary tables of Teradata.

Frequently used Tables are as follows. We have only Select DML access on data dictionary tables.

1. DBC.User

Describes in detail all information about users that the requesting user controls, including passwords.

User type:

• End User
• Teradata Database Administrator
• Supervisory

2. DBC.Sessioninfo

Gives one row for each time the user is logged on; used as a review of accounts set by user.

User type:

• Teradata Database Administrator
• Supervisory
• Teradata Database Security Administrator
• [X]End User

Select * from DBC.SessioninfoX ==> Will give information about only that user.


Popular posts from this blog

SQL for Quantile Function in Teradata

3 Uses of SAMPLE function in Teradata

3 Types of Temporal Tables in Teradata