In which table all profile which are there in SAP

[former_member609182]

from UST* I can find the profile which are assign to user.

I want to know in which table sap has stored its all profile which are available.

In most of the TABLE Profile with name "SAP_ALL" is not listed. Is there any table avliabel in sap wher I can find all profile in sap database

[jbennett1]

A few thoughts:User profile assignments are in UST04. Where users have Composite profile(s) assigned, UST04 shows only Composite profile assignments (versus or in addition to the Single profiles within the Composite), so you'd have to look at table UST10C to see which single profiles are contained within the composite.

Another note to consider re: UST10C is that composite profiles can also be nested endlessly (or at least up to 6 or 7 layers deep that I have witnessed), so you may have to loop Composite profiles which are also included in other Composite profiles through UST10C a few times to get to the true parent Composite profile.

Profile master table is USR10, which can tell you the type of profile (i.e., composite, single, generated, etc.). For generated profiles, you can use table AGR_1016 or AGR_1016B to see what roles contain the generated profiles (do not use AGR_PROF for this, which only contains the first / primary profile generated for a role, and is thus incomplete where multiple profiles are generated simultaneously for the associated role).

So, when a role is created via PFCG and generates the associated profiles, SAP will update tables AGR_1016 with the role to profile relationship(s), USR10 with the profile metadata, UST10S with the profile to authorization / authorization object relationship(s), AGR_1251 with the role's authorization values, and UST12 with the root authorization values.

Hope that helps, thanks.

Josh

[Colleen]

SAP_ALL is a composite profile. Search in the authorisation filed (AUTH) for &SAP_ALL*

[former_member144617]

Check table AGR_1016B to find what profiles are thier in a particalur role.

Foe Ex: User is having 8 roles assigned , then you can find the profile linked to these 8 roles form the above given table.