How to set row limit for particular role?

Database
Fan

How to set row limit for particular role?

Hi,

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?

Thanks alot. 

 

2 REPLIES
rjg
Supporter

Re: How to set row limit for particular role?

Darnik,

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.

 

Rglass

Fan

Re: How to set row limit for particular role?

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?

 

Thanks