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.

37 comments:

  1. Hi this is Kathiresan i am having 3 years of experience as a dot net developer and i am certified. i have knowledge on OOPS concepts in .NET but dont know indepth. After learning android will be enough to get a good career in IT with good package? and i crossed Android Training in Chennai website where someone please help me to identity the syllabus covers everything or not??

    Thanks,
    kathiresan

    ReplyDelete
  2. Hi this is Kathiresan i am having 3 years of experience as a dot net developer and i am certified. i have knowledge on OOPS concepts in .NET but dont know indepth. After learning android will be enough to get a good career in IT with good package? and i crossed Android Training in Chennai website where someone please help me to identity the syllabus covers everything or not??

    Thanks,
    kathiresan

    ReplyDelete
  3. Very helpful for us and gained more knowledge from it. We are very greatful and thanks a lot.
    Microsoft Dynamics AX Training | Teradata Training Bangalore

    ReplyDelete
  4. Your blog is really useful for me. Thanks for sharing this useful blog..Suppose if anyone interested to learn Android Course in Chennai please visit fita academy which offers best Android Training Chennai at reasonable cost.

    ReplyDelete
  5. I am glad to find your impressive way of writing the post.Thanks for sharing the post.Also see my blog Professional Civil Construction Companies in Chennai

    ReplyDelete

  6. Thank you so much... i didn’t have the knowledge in this now i get an idea about this.. thks a lot:-) Best Dot Net Training in Chennai

    ReplyDelete
  7. This information is impressive..I am inspired with your post writing style & how continuously you describe this topic. After reading your post,thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic
    Android Training in Chennai

    ReplyDelete
  8. I like this article thanks for sharing the information.
    abap-training in chennai

    ReplyDelete
  9. very informative blog. helps to know about the tera data dictionary. thanks for sharing this information. please update this type of information
    Manual Testing Training in Chennai

    ReplyDelete
  10. It is very nice article.I like this information.I really appreciate this blog.
    Java j2ee Training in Chennai

    ReplyDelete
  11. Nice..Its very good article on how to handle the future technology. This content creates a new hope and inspiration with in me. Thanks for sharing article like this. The way you have stated everything above is quite awesome. Keep blogging like this
    Android Training in Chennai

    ReplyDelete
  12. thanks for sharing about wonderful information about sql used teradata and also thanks for shared how to use it . keep sharing.
    Loadrunner Training in Chennai

    ReplyDelete
  13. It is really a computer dictionary of SQL it is really a good idea for to find new concepts and meanings , thanks for sharing.


    dot net training in chennai

    ReplyDelete
  14. very informative blog. It gives an detailed explanation about an sql concept and its techniques.Thanks for posting this information
    ssas training in chennai

    ReplyDelete
  15. this blog is useful and is informative also.This SQL data is excellent and is using the more benefits.

    Sharepoint admin training in chennai

    ReplyDelete
  16. Here are some of the mobile app testing tools that are effective in making the mobile app success.Official Blog

    ReplyDelete
  17. nice posts..
    SAS Institute introduced the SAS Certified Professional Program,training proper understanding of how the SAS software works. Among the five certification programs that SAS Institute has come up with, SAS training can be considered as the entry point into the big data and the data analytics industry.
    SAS online training in hyderabad

    ReplyDelete
  18. SAP HANA training in hyderabad,This is the best path You can Learn COmplete Course with full fledge knowledge of SAP.
    SAP HANA online training


    ReplyDelete
  19. teradata data dictionary frequently nice posts..

    Hadoop training in hyderabad.All the basic and get the full knowledge of hadoop.
    hadoop training in hyderabad

    ReplyDelete
  20. Blog Very Nice its such a useful information. Keep post

    Android training in chennai

    ReplyDelete
  21. Wonderful Post. With one of a kind substance, I truly motivate enthusiasm to peruse this post. I trust this article help huge numbers of them who looking this pretty data.
    Hadoop Training in Chennai
    Hadoop Training Chennai

    ReplyDelete
  22. Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing.
    Regards,

    Best Android Training in Chennai | Best iOS Training in Chennai

    ReplyDelete
  23. Thank you for sharing such a nice and interesting blog with us. i have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information
    We at Colan Infotech Private Limited best web design company in chennai,is Situated in US and India, will provide you best service in
    Professional Website Design Services and Colan Infotech has a group of exceedingly dedicated,
    inventive and creative experts with an energy for delivering exciting , helpful and stylish Web and Mobile Applications,
    We provide all sort of web designing services in chennai and
    of course we stepped in bangalore too we are best website designers in bangalore can provide web design services in bangalore, hire web designer india

    ReplyDelete





  24. It's interesting that many of the bloggers your tips helped to clarify a few things for me as well as giving.. very specific nice content. And tell people specific ways to live their lives.Sometimes you just have to yell at people and give them a good shake to get your point across.
    Web Design Company
    Web Development Company
    Mobile App Development Company

    ReplyDelete

  25. Really it was an awesome article...very interesting to read..You have provided an nice article....Thanks for sharing..
    Web Design Company
    Web Development Company

    ReplyDelete
  26. These ways are very simple and very much useful, as a beginner level these helped me a lot thanks fore sharing these kinds of useful and knowledgeable information.
    Android App Development Company

    ReplyDelete
  27. great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome...Thank you very much for this one.
    Web Design Development Company
    Web design Company in Chennai
    Web development Company in Chennai

    ReplyDelete
  28. it is really amazing...thanks for sharing....provide more useful information...
    Mobile app development company

    ReplyDelete
  29. You have provided an nice article, Thank you very much for this one. And i hope this will be useful for many people.. and i am waiting for your next post keep on updating these kinds of knowledgeable things...
    Fitness SMS
    Salon SMS
    Investor Relation SMS

    ReplyDelete