#DateForumTypeThreadPost
2209 Sep 2015 @ 10:57 PDTDatabaseReplygrant on viewI have a view abc.acd and i am granting select access to role role_1 Grant select on abc.acd to role1; XYZ,LMN is the user in role1 but when selecting the view through XYZ,LMN user's its giv...
2109 Sep 2015 @ 10:48 PDTDatabaseTopicgrant on viewHi All,   I have a view abc.acd and i am granting select access to XYZ user Grant select on abc.acd to xyz; but when selecting the view through XYZ user its givi...
2008 May 2014 @ 11:53 PDTDatabaseTopicStored procedureHi All,   Need to create a user using stored procedure. I am using the below code and getting an error CREATE PROCEDURE abc.MyFirstProc(    IN user_name VARCHAR(12),  &nb...
1919 Apr 2014 @ 09:28 PDTDatabaseTopicRegarding date formatHi all,   I created a table  create table financial.test  (empid integer not null,   ename char(30),  hiredate DATE FORMAT 'ddmmyyyy' ) p...
1831 Mar 2014 @ 11:33 PDTDatabaseReplyFind role and associated priveleges with it. Hi ,   You can get all the information in dbc.allrolerightsv RoleName DatabaseName TableName ColumnName AccessRight GrantorName ...
1731 Mar 2014 @ 10:44 PDTDatabaseTopicPPI on CompressionHi All, Can we create PPI on Compressed columns? If yes, pls share me link where i can get info or material.   Thanks, Praveen.
1622 Jan 2014 @ 11:53 PSTCloud ComputingReplyNeed software link to downloadThanks Raja :) 
1522 Jan 2014 @ 08:51 PSTCloud ComputingTopicNeed software link to downloadHi All,   I am using windows 7 professional service pack 1, 32 BIT operating system. I need to practice TD. Can any one pls help me where i can download software for this. Can i go for Vm wa...
1409 Jan 2014 @ 03:54 PSTDatabaseReplyDate partitioned tablesThanks Khurram :)
1308 Jan 2014 @ 08:09 PSTDatabaseTopicPDCR (Performance Data Collection and Reporting database)Hi , Can any one explain about PDCR. Pls help me where i can get required information. Regards, Praveen
1208 Jan 2014 @ 08:06 PSTDatabaseTopicDate partitioned tablesHi All,   Can any one tell me how to pull all the date partitioned tables from the system.   Regards, Praveen
1102 Jan 2014 @ 08:58 PSTDatabaseReplyRegarding dbc.qrylogsql table's sqltextinfoHi Raja,   Thanks for the quick response... If i am joining with dbc.qrylog its getting plain txt but if i joined with dbc.qrylogtbl i am getting .txt files.   Regards, Praveen.
1002 Jan 2014 @ 08:26 PSTDatabaseTopicRegarding dbc.qrylogsql table's sqltextinfoHi All, I am using the column sqltextinfo in dbc.qrylogsql table and its giving .txt files. Can i get plain text in the table itself. Regards, Praveen.
919 Dec 2013 @ 03:08 PSTDatabaseReplyRegarding TVS VprocThanks Raja :)    Regards, Praveen
818 Dec 2013 @ 07:24 PSTDatabaseReplySpool space issueHi,   Check the number of sessions connected or queries executed by the user.   Regards, Praveen
718 Dec 2013 @ 07:20 PSTDatabaseTopicRegarding TVS VprocHi All,   Can anyone explain What is TVS Vproc and why its needed?   Regards, Praveen
629 Nov 2013 @ 02:29 PSTDatabaseReplyRegarding StatementText in accesslogHi Dieter, I am not sure on that . I will check with it. Thanks. Regards, Praveen.
529 Nov 2013 @ 01:43 PSTDatabaseReplyRegarding StatementText in accesslogHi Dieter, Thanks for the reply but when i used the below query  sel  StatementText from dbc.accesslog where  UserName=  'abcd' and LogonDate= '2013/11/28&#...
428 Nov 2013 @ 07:20 PSTDatabaseTopicRegarding StatementText in accesslog While i am executing this query it is showing zero records    sel  StatementText  from dbc.accesslog where  UserName=  'abcd' and LogonDate=11/2...
315 Apr 2012 @ 02:20 PDTDatabaseReplySQL assistance--find mismatches in daily data Hi dnoeth, Can you pls give the query for finding the space occupied by Indexes only. Thanks, Praveen
215 Apr 2012 @ 02:18 PDTGeneralReplyNewbie -- where to start learning teradata? Hi All, how did we get to know the space occupied by indexes only ? Pls can any one share the query.   Thanks, Praveen
128 Jan 2012 @ 08:09 PSTGeneralReplyNewbie -- where to start learning teradata? Hi all,     I am also newbie.... and want to learn teradata dba nay one pls suggest where to start Thanks, Praveen