Fusion : Table which stores UserIds against Role names?

User618255-OC

Hi,

I have a question.

Is there a table in Fusion which stores which user is assigned to which role. Is this a BPM table?

Thanks a lot for your help!

-abhishek

Surendar Babu

HI,

Use this code to get the Person Number and Roles Mapped to the User.

SELECT DISTINCT

EMPL.PERSON_NUMBER,

PRD.ROLE_NAME

FROM

PER_USER_ROLES UR,

PER_USERS PU,

PER_ALL_PEOPLE_F EMPL,

PER_ROLES_DN_VL  PRD

WHERE

PU.USER_ID = UR.USER_ID

AND PU.PERSON_ID = EMPL.PERSON_ID

AND UR.ROLE_ID = PRD.ROLE_ID

Thanks & Regards,

Surendar Babu S D