A permission set grants select-only access to accounting tables for a read-only database user, but when querying those tables, only the column headers show — no actual row data comes back, even though the permission set itself looks correctly configured.

All FAQ questions / Security and access

Answer

Check whether the user has Company and Site actually assigned, not just the object-level select privileges from the permission set — a permission set that correctly grants select access to the underlying tables/views still won't return row data if the user's own setup is missing a Company/Site assignment, since most accounting views filter or depend on that context. Confirming the user's Company/Site setup, not just their permission set grants, is usually what's actually incomplete in this scenario.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Security and access questions