You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

which Table relates permission list and query access group.

3 replies [Last post]
Guest's picture
Guest

Hi All,
I am newbie to peoplesoft. Is there any table to to relate permission list(PSCLASSDEFN) and Access group(ACCESS_GRP_TBL).

Manoj Gangal's picture
Manoj Gangal (not verified)
Re: which Table relates permission list and query access ...

Try querying the PS_SCRTY_ACC_GRP table

Guest's picture
Guest (not verified)
Re: which Table relates permission list and query access ...

Thanks Manoj.

Deanna's picture
Deanna (not verified)
Re: which Table relates permission list and query access ...

if this is try, how does one derive the objects that are attached to the query access group?