Thursday, July 30, 2015

SQL to get the list of query security trees that an oprid has access

SELECT distinct P.TREE_NAME,P.ACCESS_GROUP,P.ACCESSIBLE
      FROM PS_SCRTY_ACC_GRP P, PSROLECLASS C, PSROLEUSER R
     WHERE R.ROLENAME = C.ROLENAME
       AND P.CLASSID = C.CLASSID
       AND R.ROLEUSER = 'User ID'
       AND P.ACCESSIBLE = 'Y'
     ORDER BY 1,2;

No comments:

Post a Comment