SELECT a.name,
a.first_name,
b.role_id,
c.description
FROM grc_sec_user a,
grc_sec_user_job_xref b,
GRC_SEC_JOB_ROLE_TL c
WHERE a.id = b.user_id
and b.role_id=c.id
and c.language = 'US';
Apart from these, one can also refer the following tables:
GRC_SEC_DATA_ROLE_TL, grc_sec_duty_role_tl, GRC_SEC_PERMISSION_TL.
a.first_name,
b.role_id,
c.description
FROM grc_sec_user a,
grc_sec_user_job_xref b,
GRC_SEC_JOB_ROLE_TL c
WHERE a.id = b.user_id
and b.role_id=c.id
and c.language = 'US';
No comments:
Post a Comment