Smart Results Grid also provides admins with the ability to set a row limit for their users, which is extremely helpful for controlling the cleanliness and order in your SQL.
- To access this option, go to the Administration tab on the main menu and select Global Preferences, as shown below.
- Aginity will display a pop-up window with the fields to fill. Check the "Limit rows number to" box, and specify the number you want to allow for query execution. Click the 'Apply' and then 'OK' buttons, and you're all set.
- Unlike administrators, regular users won't be able to change the row limit or overcome it.