UME Database tables.

[Former Member]

Hi,

We are using SAP EP 7.0.LDAP is used as the datasource for the UME. It means user authentication is doneagaint the Users stored in LDAP.

I have the following question on the UME.

1)Is the User ID also stored in UME in this case(when LDAP is used as datasource) since the Portal Roles assigned to each user must be stored in the UME database.

2) How the mapping happens between the user ID in Portal and User ID in LDAP?

3)What are the Database tables that store these details. How to access these tables?

4)Is there any documentation for the Table fields given by SAP.

Regards

Veera

[detlev_beutner]

Hi Veera,

1.) The users are stores in the table UME_STRINGS

2.) This is defined by UME settings (ume.ldap.unique_user_attribute), see http://help.sap.com/saphelp_nw70/helpdata/en/63/14f5b51a6eff429f2d8b2063400e82/frameset.htm

3.) See 1.

4.) No.

Keep in mind that the DB structure in general should be a black box for any developer; normally the API provides everything you need for accessing the data. Even if this won't happen very often to the UME tables - but altering the DB structure is something SAP may do without prior notice.

Hope it helps

Detlev