Regarding authorizations

[Former Member]

Hi,

As a principle of Segregation of duties, i need a report that shows the user's authorizations that in fact she should not have together.

For example, it is not good to have VK11 and VA01 together or CK11 and MM01 etc..And i want to get these auth. data depending on some criteria like WERKS, VKORG, VTWEG etc.

From which tables can i get the transaction codes that a user has and how can i use werks vkorg to select trans of a user?

Thanks.

deniz.

[Manohar2u]

Look at below tables

AGR_1251 for tcodes (object S_TCODE & low will have tcode details )

AGR_1252 for org values like company codes, controlling areas etc..

[GauthamV]

Tables : USR04,USR12.

[Manohar2u]

AGR_USERS table will give you list of roles assigned to user - and then continue with above tables to drill down to tcodes and org level values.

[Pawan_Kesari]

Trasnction SUIM (User information system) give you plenty of report. I am sure one of them will solve your problem.

[Former Member]

Report RSUSR008_009_NEW.

Free of charge, if you are willing to put in a bit of effort...

Cheers,

Julius