Re: PeopleSoft Security Info

Re: PeopleSoft Security Info

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by [IP Address: 63.162.27.25] 'Erik' on September 13, 2001 at 16:44:33 EST:

In Reply to: PeopleSoft Security Info posted by [IP Address: 63.162.27.25] 'Holly Schmitmeyer' on July 19, 2001 at 09:52:01 EST:

I use PS 7.5 and Oracle 8. The tables that are set up are as far as I know 'out of the box'. I run the following SQL script in SQL Plus to get a list of all operators and all classes that they are a member of.

select a.oprid, a.oprdefndesc, a.emplid, b.oprclass
from psoprdefn a, psoprcls b
where a.oprid = b.oprid
order by 1, 4;

You can spool this to a .lis file and open it in Excel. Rember to enter: SET PAGESIZE 999 to remove unwanted page brakes.

Follow Ups:

Post a Followup

Name:
E-Mail:
Subject:
Message: : I use PS 7.5 and Oracle 8. The tables that are set up are as far as I know 'out of the box'. I run the following SQL script in SQL Plus to get a list of all operators and all classes that they are a member of. : select a.oprid, a.oprdefndesc, a.emplid, b.oprclass : from psoprdefn a, psoprcls b : where a.oprid = b.oprid : order by 1, 4; : You can spool this to a .lis file and open it in Excel. Rember to enter: SET PAGESIZE 999 to remove unwanted page brakes.