Skip to content

Is there a way to see which users are (or aren't) connected to a specific Base Profile?

Answer

For users connected to a Base Profile, the Base Profile details screen shows its content and the users assigned directly. For users NOT connected to any base profile, run a Quick Report: SELECT IDENTITY FROM FND_USER WHERE ACTIVE = 'TRUE' AND IDENTITY NOT IN (SELECT IDENTITY FROM FNDRR_USER_CLIENT_PROFILE WHERE ORDINAL = 1) — this returns active users who don't have a base profile (ORDINAL = 1) assigned, and can be adapted with additional filters if you need a more specific subset.

← Browse Security and access questions