topic Re: Regarding authorizations in Application Development and Automation Discussions

Regarding authorizations

Former Member — Fri, 03 Apr 2009 13:33:58 GMT

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.

Re: Regarding authorizations

Manohar2u — Fri, 03 Apr 2009 15:07:08 GMT

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..

Re: Regarding authorizations

GauthamV — Fri, 03 Apr 2009 15:09:42 GMT

Tables : USR04,USR12.

Re: Regarding authorizations

Manohar2u — Fri, 03 Apr 2009 15:11:38 GMT

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.

Re: Regarding authorizations

Pawan_Kesari — Fri, 03 Apr 2009 15:48:15 GMT

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

Re: Regarding authorizations

Former Member — Tue, 07 Apr 2009 23:04:49 GMT

Report RSUSR008_009_NEW.

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

Cheers,

Julius