UME table names

[Former Member]

Hi experts,

Can anybody tell me what are the UME table names in J2EE schema. I mean in which tables the J2EE UME user data are stored?

Thanks,

Sudip.

[Former Member · Accepted solution]

Have a look at table UME_STRINGS. There are a few others starting with UME_*.

Regards, Michael

[Former Member · Accepted solution]

Hi mho,

This doesn't solve my problem.

I searched the UME_* tables in the database and these table doesnot contain user related data.

The UME_STRINGS tables also not Sufficient to resolve my problem.

I require the tables where UME user ID, First name, last name, User type, Assigned roles, account information, contact information etc etc will be available.

Thnaks,

Sudip.

[markus_doehr2 · Accepted solution]

Do you use UME to store that data? I mean, is it the UME you authenticate against? If you use e. g. a Portal it's very likely that the UME uses the ABAP backend for the authentication.

Markus

[Former Member · Accepted solution]

Hello Markus,

Our system is NetWeaver J2EE system which contain GRC components and and we use UME to store data. And it does not connect to any backend system to store user data.

Thanks,

Sudip.

[Former Member · Accepted solution]

You might need to have a second look... I was not guessing a random table name.

SQL> select pid, attr, val from sapsiddb.ume_strings
where pid = 'USER.PRIVATE_DATASOURCE.un:mho'

PID                                  ATTR                 VAL
------------------------------------ -------------------- ----------------------
USER.PRIVATE_DATASOURCE.un:mho   lastname                 HO
USER.PRIVATE_DATASOURCE.un:mho   email                    mho-at-noway.com
USER.PRIVATE_DATASOURCE.un:mho   company
USER.PRIVATE_DATASOURCE.un:mho   accessibilitylevel       0
USER.PRIVATE_DATASOURCE.un:mho   locale                   en_US
USER.PRIVATE_DATASOURCE.un:mho   uniquename               mho
USER.PRIVATE_DATASOURCE.un:mho   PRINCIPAL_CREATION_DATE  0001244788186528
USER.PRIVATE_DATASOURCE.un:mho   firstname                Michael
8 rows selected. 

Sincerly yours, Michael

[Former Member · Accepted solution]

Hi Michael,

Thank you very much for your prompt reply.

Thanks,

Sudip.

[former_member633852 · Accepted solution]

Hello,

Try following sql command ;

select pid from sapsr3db.ume_strings where pid like 'USER.PRIVATE_DATASOURCE.un:%' group by pid order by UPPER(pid);

Regards

Atakan