User DB

[Former Member]

Hi All!

I'm trying to find the database table, where the user managment engine stores the user data. In the abap stack you got the table USR02, is there an equivalent in the Java Stack?

My aim is to read the user data (and role assignment)from DB, either with SQL or the equivalent eventualy existing java methods.

regards,

Alexander Kuehne

Message was edited by: Alexander Kühne

[former_member182372]

Hi Alexander,

Actually it is not really good practice to read service layer data directly from DB instead of using API. For user data reading you should use UME ( https://media.sdn.sap.com/javadocs/NW04/SPS15/um/index.html ). The start point is UMFactory class (https://media.sdn.sap.com/javadocs/NW04/SPS15/um/com/sap/security/api/UMFactory.html). And here is an <a href="http://www.sapprofessionals.org/?q=creating_assignments_of_users_to_groups_or_roles_using_the_ume_api_isvery_slow">Example</a>

Best regards, Maksim Rashchynski.

[Former Member]

Hello Maksim,

I do not happen to have the library com.sap.security.api . Where can I get it? Do I have to connect to a JDI, is it obligatory?

Best regards,

Alexander Kuehne

[former_member182372]

Hi Alexander,

If you have NWDS, you can check here <INSTALLATION_FOLDER>\SAP\JDT\eclipse\plugins\com.sap.tc.ap\comp\SAP-JEE\DCs\sap.com\com.sap.security.api.sda\_comp\gen\default\public\default\lib\java\com.sap.security.api.jar

Best regards, Maksim Rashchynski.