#DateForumTypeThreadPost
2524 Apr 2015 @ 07:25 PDTDatabaseTopicHow to get the user information.Hi, I want to get the following details (User ID, full name of the user and email address) of the user. Can some one help me from which DBC table / View I can find these details of the user? Thank...
2425 Mar 2015 @ 04:20 PDTConnectivityTopicSolution to reset initial password in Teradata through ODBC client applications.Hi All, Can someone help me to find the solution for below issue? Thanks! When ever new business users are created, they are provided with initial password which they need to reset the first time...
2324 Mar 2015 @ 05:42 PDTConnectivityReplyPassword encryption mechanism for ODBC client application users.Hi, Thanks for the update. But, I've seen following statement in 'ODBC Driver for Teradata 14.10' user guide  under section Password Encryption: Logon encryption is used automat...
2223 Mar 2015 @ 09:18 PDTConnectivityTopicPassword encryption mechanism for ODBC client application users.Hi All, Can someone help me to understand more about password encryption with respect to ODBC client applications. As far as I know, password will be encrypted and stored in the database table by ...
2118 Mar 2015 @ 05:58 PDTConnectivityTopicSetting up ODBC Driver setup parameters and ODBC Driver options globally.Hi All, Good Day... Can some one help me to set up ODBC Driver for Teradata options (Especially, Password & Data Encryption and Authentication Mechanisms) globally and these optios should not...
2029 Dec 2014 @ 07:01 PSTDatabaseReplyWhile refreshing the table.Hi Chew, Its not a big table and rows are lesser than 100000, I'm deleting rows directly from base table (using delete from table command) without using any view.   Thanks, Sri.
1929 Dec 2014 @ 06:37 PSTDatabaseReplyWhile refreshing the table.Hi RGlass, We are not using any utility, we are just deleting all the data (delete from table) and then iserting new data into that table. During this period (i.e., after deleting and before inset...
1829 Dec 2014 @ 01:47 PSTDatabaseTopicWhile refreshing the table.Hi All, While deleting data from one my table, my application is not functioning (until new data is available). Can someone help me to find the best way to keep the data avilable to the system unt...
1718 Nov 2014 @ 06:39 PSTDatabaseReplyFallback optionSorry colour is not visible, yellow marked records are 'B' from first row (D,B,D)of transactional data and 'C' from last row (G, C) of transactional data. Bold undelined record is ...
1618 Nov 2014 @ 06:32 PSTDatabaseReplyFallback optionThe exact requirement is as following:  In the UDF we test two data sets against each other. Dataset A – The materialized decision tree. (security rules) Dataset B – The transac...
1518 Nov 2014 @ 12:40 PSTDatabaseTopicFallback optionHi All, By default, Fallback creates two additional copies of each row and keeps in different AMPs, Is there any option if I want increase the number of copies ie., for example if I want to create...
1413 Aug 2014 @ 11:53 PDTDatabaseTopicQuery Banding functionality in TeradataHi All, As there was a drwaback “getQueryBandValue” is evaluated once per row, thus increasing CPU utilization. with respect to. Query Banding functionality in earlier versions of Tera...
1311 Jul 2014 @ 02:02 PDTDatabaseTopicAccess blocking for connection usersHi, How to implement IP based/ Host based access blocking for connection users in Teradata? Thanks in advance. Sri.
1213 Jun 2014 @ 03:44 PDTDatabaseReplyDiretct User Login Vs. Query banding.Thank you Raj...   Hi Fred, I've some idea on Query Banding functionality, but I would like to know some of the advantages and disadvantages of using Direct User Logon compare to Query ...
1112 Jun 2014 @ 06:16 PDTDatabaseReplyDiretct User Login Vs. Query banding.Thank you so much Raja... Is it possible to get a comparison sheet on Query Banding based Logon vs. Direct Logon?, can you please advise?   Thanks, Sri.
1012 Jun 2014 @ 05:21 PDTDatabaseTopicDiretct User Login Vs. Query banding.Hi, Can someone explain what are the impact differences between Direct logon and Query banding. Thanks in advance. Sri
919 May 2014 @ 05:17 PDTDatabaseTopicRecursive ViewHi All, I have a question about recursive views. Currently I have defined a view that is recursive. This works perfect (view 1). Now I want to join this view in a query, and make this query a ne...
829 Apr 2014 @ 05:25 PDTDatabaseReplyDBC.AccessLogThanks a lot Carlos...
728 Apr 2014 @ 07:49 PDTDatabaseTopicDBC.AccessLogHi All, Can some one help me, how to configure the system to store last 2 years of data in DBC.AccessLog[V], by default this view is storing 3 months of data only.   Regards, Srini.
608 Apr 2014 @ 08:17 PDTDatabaseTopicBest practices for database to database security.Hi, What are the best practices for implementing database to database security? E.g. select access on one database to another. Please provide me few important points i.e., what needs to be taken ...
508 Apr 2014 @ 08:07 PDTDatabaseReplyFinding User informationThanks for your reply Kishore. In the above case the PasswordChgDate value from DBC.Dbase is < 0 and as you said that DBC.Users view is populates null if PasswordChgDate is <0, then how would...
428 Mar 2014 @ 03:52 PDTDatabaseReplyFinding User informationYeah :), actually I'm looking for userid with initial passwd and I'm using query: select PasswordChgDate from dbc.Dbase where databasename = 'xxxx'; and the result is showing as -...
328 Mar 2014 @ 01:49 PDTDatabaseTopicFinding User informationHi, Can some one help me to find list of users and their passwords, ie., in which DD table/view we can find all users and corresponding passwords? Thanks in advance, Srinivas.
214 Feb 2014 @ 05:38 PSTDatabaseReplyDatabase HierarchiesHi Dieter and Padhia, Thanks for your quick responses.   --Srini.
112 Feb 2014 @ 07:07 PSTDatabaseTopicDatabase HierarchiesHi All, Can someone help me to find out the query for below scenario: We need to have a query based on DBC.DatabasesV to get lists of databases (Hierarchies) under a specific database (Master Dat...