Is there any way to set row limit for each role? For Eg: for a particular user, he/she can get only 1 million records for his sQL query?
you could create a TASM filter or throttle on estimated final row count.
It could be applied at the user/account or profile level for this purpose.
Thanks for the quick assistance.
Is there an option to assign max rows returned in user Security or user group Security that the user cannot change?
Any options to set it through teradata administrator for a dba?