Plants access to users

[Former Member]

Hi All,

I want to pull a report having all users with plant access.

Is there any table where we can find users having access to particular plants.

Please do the needful.

Thanks,

[Former Member]

Plant security can be found in table AGR_1252 and role assignment in AGR_Users combine those 2 for yor request

[Former Member]

The info is in a few different tables, you will need to create a query (BI, SQVI/SQ01, Access etc) that uses AGR_USERS and AGR_1252 filtered on Plant.

[Former Member]

Please ignore.

Edited by: Subramaniam Iyer on May 4, 2010 1:52 PM

[Former Member]

Thanks all