Have you tried using Globalfilters?
Please Mr David how i use global filter can you clear this.
when you filter any table in permission, you need to add the same table from other role giving all the permission in Indirect mode
Role ID | Object Type | Object ID | Read Permission | Insert Permission | Modify Permission | Delete Permission | Execute Permission | Security Filter | Role Name | Object Name |
---|---|---|---|---|---|---|---|---|---|---|
INDIRECT | Table Data | 27 | Indirect | Indirect | Indirect | Indirect | Yes | Item |
I add this permission to this role as above in indirect mode but not work