on 02-21-2014 4:24 PM
I want to see if our organization has any users who have profiles that are not part of a role. How can I do this?
Hello Alison,
connect to the databases of your ABAP systems one after the other, and execute the below query. It will give you the list of all user-profile assignments where the profile assigned to the user doesn't belong to any role.
You could verify these query results by logging into the ABAP system via SAPGUI to the client given in the MANDT column of a result set row.
Start transaction SU01 when logged in to that client, and then display the user given in the BNAME column of the same resultset row. Compare what you see on the "Profiles" tab of SU01 to the PROFILE column of the query result set.
BR, Lambert
select
p.*
from ust04 as p
left outer join agr_1016b as r
on p.mandt=r.mandt
and p.profile=r.profile
where r.profile is null
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.