2009 Apr 11 3:37 AM
All,
How can I find out the list of users who has the W R permission for IT 008
for others?
SUIM doe not look like giving me the correct results.
Please advise.
Thanks,
From
PT.
2009 Apr 11 9:27 AM
Dear Pranav,
I am sorry. But I do not understand what IT0008 is. Could you please clarify?
Regards,
2009 Apr 11 9:58 AM
combine tables AGR_1251 and table AGR_Users on keyfield AGR_USERS
in tabel AGR_1251 select on Field LOW values IT0008.OR W OR R,
noiw you get also other values
So better solution run the query twice over AGR1251 first on IT0008 and secondly on values W OR R and then the result over table AGR_USERS
Youu also might put an additional selection on object P* (only selecting HR objects)
output wll be UID in table AGR_USERS
2009 Apr 11 1:59 PM
Auke
Is it possible for you to let me know step by step.
I am not the query expert.
Thanks
From
PT.