Permission Lists Assigned to a User

Your rating: None Average: 5 (1 vote)

SQL that I find useful in many occasions. It will return a list of permissions that are assigned to a specific user.

SELECT   d.oprid, d.oprdefndesc, c.roleuser, a.rolename, a.classid,
         b.classdefndesc
    FROM psroleclass a, psclassdefn b, psroleuser c, psoprdefn d
   WHERE a.classid = b.classid
     AND c.rolename = a.rolename
     AND d.oprid = c.roleuser
     AND d.oprid = :userid
GROUP BY d.oprid,
         d.oprdefndesc,
         c.roleuser,
         a.rolename,
         a.classid,
         b.classdefndesc;
-- at run time, substitute :userid with the user id you want the SQL to run against.

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!

Comments

Have a question? Please ask it on the forum instead.
Guest's picture
Guest (not verified)
Find the pages which inserts into a record in peoplesoft.

In people soft, I have a Record Name. Would like to know the pages and the components which inserts into this record. Please provide and SQL query where IF USER input is the Record Name the output is the list of PAGES which inserts into the record.

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
2 + 1 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.