View Permissions by Record

Prev Next

COBBLESTONE SOFTWARE

Contract Insight — User Guide

View Permissions by Record

03. Admin User Manual › Employee/User Management › View Permissions by Record

Note: Each procedure in this guide begins at the Contract Insight homepage, so any section can be followed on its own. Custom fields are configurable, so the exact field list on a contract category record may vary between environments.

1. Overview

Seeing which specific records a permission applies to is done through the same Rules & conditions builder used to define the scoping in the first place (Administration > Manage User Permissions, a permission's Rules tab). The builder's Stored condition line shows the exact SQL WHERE clause currently in effect, and its Count matching records button runs that condition live against the database and returns how many records it currently resolves to — giving a direct, verifiable answer to "which records does this permission reach" without needing to browse the records individually.

2. Key Elements

  • Open a permission from Administration > Manage User Permissions and switch to its Rules tab to see the condition(s) currently scoping it to specific records. The tab label shows on when rules are defined.
  • The Rules column of the Manage User Permissions list shows Limited by rules for a permission scoped to a subset of records, and – for a permission with no rules, which applies to every record in its area.
  • The Stored condition line renders the rule as a literal SQL WHERE clause (e.g. where (tblContracts.u_GovernmentContract = 'Yes' AND tblContracts.Employee_ID = @EmpID)), making the exact record-level scope of a permission transparent rather than implicit. @EmpID stands for the person signed in ("only my own records").
  • Count matching records executes that condition against live data and reports the number of records it currently matches, letting an administrator confirm a rule's real-world reach before or after saving it.
  • Built-in permissions show their stored condition read-only — their name, area, action and rules are part of the product and can only be turned on or off for granting.

3. Opening Manage User Permissions

Manage User Permissions lists every permission that can be granted to a security group or to one person, along with the area it covers, the action it allows, whether it is limited by rules, who it is granted to, and its status.

  1. From the Contract Insight homepage, click the Administration (sliders) icon at the bottom of the left navigation bar.
  2. Type permission in the Search administration box (or scroll to the Security & Access category).
  3. Click Manage User Permissions.

Administration page filtered to Security and Access tools

Manage User Permissions list

4. Finding Permissions That Are Limited by Rules

Use the Rules column to tell at a glance which permissions reach only a subset of records. Limited by rules means the permission has a stored condition; – means it applies to every record in its area.

  1. On the Manage User Permissions page, type part of the permission name in the grid Search box (for example, My Contracts) and press Enter.
  2. Check the Rules column for Limited by rules, and the Granted to column for how many groups or people hold the permission.
  3. Click Manage on the permission you want to inspect.

Permissions list searched for My Contracts showing Limited by rules

5. Viewing a Permission's Rules

A permission opens on its Details tab, which shows its name, area, action, and who it is granted to (with links to grant it from a security group or from one person's permissions). The Rules tab shows which records it reaches.

  1. Review the Details tab to confirm the permission's Area and Lets people action.
  2. Click the Rules tab.
  3. Review the condition rows (field, operator, value) and the Match setting (ALL by default), which controls how the conditions combine.
  4. Read the Stored condition line for the exact WHERE clause in effect.

Details tab of a custom permission

Rules tab with conditions and stored condition

6. Counting the Records a Permission Reaches

Count matching records runs the stored condition against live data and reports how many records match right now. Because conditions that use The person signed in (@EmpID) resolve to you, the result is the count for you, as noted next to the number.

  1. On the permission's Rules tab, click Count matching records.
  2. Read the result on the right (for example, "0 records match right now, for you.").
  3. If you adjust the conditions, click Count matching records again to check the new reach, then click Save rules to keep the change.

Count matching records result

7. Rules on Built-in Permissions

Built-in permissions (Status shows Built-in) display a banner explaining that their name, area, action and rules are part of the product. Their Rules tab shows the stored WHERE clause as read-only text, without the condition builder or the Count matching records button — only their availability for granting can be changed.

Rules tab of a built-in permission

8. Quick Reference Summary

TaskHow to Complete It
Open the permissions listAdministration (sliders icon) → Manage User Permissions.
See whether a permission is scoped to specific recordsCheck the Rules column: Limited by rules = scoped; – = every record in its area.
View a permission's conditionsManage → Rules tab.
See the exact record scopeRules tab → Stored condition line.
Count the records a permission reachesRules tab → Count matching records.
Save a change to the conditionsRules tab → Save rules (custom permissions only).
See who holds the permissionGranted to column, or the permission's Details tab.