Please help how to find details of base profile in back end .. i cant see any views in system info
Best answer by Charith Epitawatta
I can only find Profile ID in this table , could you please help me to find the base profile name which is associated with these id’s
If all you need is just the base profile IDs and their names, then following query mentioned in
Base profiles can be identified using following query
select * from CLIENT_PROFILE where owner is null
I should also highlight that a certain profile appears in FNDRR_USER_CLIENT_PROFILE_TAB only if it is assigned to a user. Otherwise it will not show up here. So to list down all base profiles, regardless of whether they are assigned to a user or not, above query is more accurate.
You can JOIN these tables as necessary using the Profile_ID column to fetch any other data you need since it is common to them all.
Hope this helps!