JDBC Role Configuration In 12.1

[former_member1170711]

We are trying to migrate from our 11.5 MII system to a 12.1 system. In 11.5 we are using JDBC to access an Oracle table for authorization (not authentication). In other words, our MII 11.5 is configured such that, after a user is authenticated, does an SQL query to an Oracle table to see what roles the user is in. This info is subsequently used in the role-based portal, etc.

In 11.5 this configuration is done in Security Manager->User Management->JDBC Configuration. For example we configured a query in the u201CSelect Roles For Useru201D section of this page as follows:

select unique(role) from my_user_role_table where lower(user_id)=lower(?)

We would like to use the same technique in 12.1. Is this possible and, if so, where/how is this configured?

Thanks,

Mike

[jamie_cawley]

This may help you

http://help.sap.com/saphelp_nwce711/helpdata/en/49/6b24192f301b93e10000000a42189b/frameset.htm

as you see on the page you may want to look at some other options.

Regards,

Jamie

[former_member1170711]

Hi Jamie,

This is what I was afraid of. Thanks for you help.

-Mike

[former_member1170711]

We know about the UME. The question is, can this be done with the UME and, if so, how?

[Former Member]

Starting MII 12.0, the UME is located on the Netweaver side. Worth taking a look there.