Which are the tables stores USERS, ROLES & GROUP List in EP?

[pr_srinivas]

We have installed NW 2004s with Usage Type EP.

We want to know which tables stores the user , roles & groups list in JAVA SCHEMA?

Regards

PR

[pr_srinivas · Accepted solution]

can any one help in this regard ? please !

Rgds

[Former Member · Accepted solution]

Hello,

you'll find most of what you need in UME_STRINGS, the UME saves things as a history of users.

To find out which accounts are locked you can use this for example:

SELECT PID FROM SAP<SID>DB.UME_STRINGS where ATTR = 'islocked' and VAL = 'true'

Regards,

Andi