Below are the steps to create a rule that prevents a user named thomas_cook from seeing more than 5 rows when the user runs a query on a published table /services/databases/examples/ViewOrder.

1. Go the the TDV (TIBCO Data Virtualization) Web Manager, and click on Configuration >> Workload Management.



2.   Click the Add Rule button, and enter a name for the rule.



3.  From the drop-down menu next to Rule Type, select the Row Limit option and Actions type as 'Exception'. Type 5 into the Maximum Row Count field. This will limit the user to seeing a maximum of 5 rows.

             

 

Note: Only action type 'Exception' would act like a hard limit. All the other action types would be considered as soft warnings and would not actually limit the number of rows retrieved by the user. 


4.  In the Users/Groups section, click the green "+" button to add a new entry. Configure the new entry as follows:

     ----------------------
      Domain            :   composite  (change this if another domain is being used)
      Member Type  :   User
      Name               :   thomas_cook
     ----------------------



5. In the Resources section, click the green "+" button to add a new entry. Add the full pathname of the published table

Example:  /services/databases/examples/ViewOrder




To test the rule: Connect to the TDV server as thomas_cook using any client application (e.g. DB Visualizer) and run a query on the published table
Example:  select * from ViewOrder;