Wednesday, 3 June 2015

Oracle GRC Role query

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.

No comments:

Post a Comment