What are the PeopleSoft Security Tables ?
PSROLECLASS
PSROLEUSER
PSOPRDEFN
PSROLECLASS: Provides the permissions lists associated to each role.
PSROLEUSER: Gives Information about the role assigned to the Operator ID.
PSOPRDEFN: This table holds the PeopleSoft Operator ID and Operator Password
information with Symbolic ID.