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

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
Teradata Database Security Administrator
[X]End User

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

No comments:

Post a Comment

Featured post

5 Top Teradata DATE functions to read now

The following are the list of DATE functions. These are very frequently being used in Teradata. The following statement requests the cur...

Popular Posts