05-04-2010 11:26 AM
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,
05-04-2010 11:40 AM
Plant security can be found in table AGR_1252 and role assignment in AGR_Users combine those 2 for yor request
05-04-2010 11:40 AM
Plant security can be found in table AGR_1252 and role assignment in AGR_Users combine those 2 for yor request
05-04-2010 11:42 AM
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.
05-04-2010 12:51 PM
05-05-2010 2:34 PM