Extracting Roles via Direct Database Queries

Question: I'm trying to make some reports that will show the roles defined within SAP, and which users are assigned to which role. Basically, we're trying to show who can do what.

I've seen in the archives links to SAP scripts to get that information. But is there a way to just query the underlying database directly? Are the permission/roles table(s) for SAP defined/documented anywhere, or does anyone know which tables and columns have what information?

Thanks!
Jim

Answer:
Check AGR_USERS table, I guess that provides the same info which you
are planning to do as a report.

Answer:
Look at all the tables that start with AGR.
_________________
bwSecurity
Copyright ?2007 - 2008 www.jt77.com