Thursday, 15 January 2015

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.

No comments:

Post a Comment

5 Top Teradata DATE functions read now

  The following are the list of DATE functions. These are very frequently being used in Teradata. Current DATE The following statem...