If
users/groups and
resources are not assigned to a Workload Management rule, it is called a Global rule. The rule will be applied to:
- All users except for the following:
(a) The default admin user
(b) Users in an admin group
(c) The dre user
(d) The dre_manager user.
- All resources except system resources.
Below is an example of creating a Global rule that restricts the number of rows returned to 7.
Example (1) Create a rule to limit the number of rows returned to 7. Do not add any users or groups to the
User/Groups/Claims panel, and do not add any resources to the
Resources panel.
(2) Connect to TDV using a client application e.g. DBVisualizer. Ensure that the user who is connecting does not belong to an admin group.
(3) Run a query on a table containing more than 7 rows. TDV will return only 7 rows instead of returning all the rows.
As the rule's Action is
Log Server Event, cs_server_events.log will contain an entry of the type below:
======
2022-08-10 18:38:53.041 -0700 INFO WorkloadRuleViolation
Workload rule violated : Workload rule 'Rule_for_row_limit'.
Request exceeded 7 row(s). MyRule: row limit is 7. 22 ann_smith composite 22101 6640727732165 6640727732165 Workload rule 'Rule_for_row_limit'. Request exceeded 7 row(s). MyRule: row limit is 7.
======