SQL | PeopleSoft Tutorial

Tag Archive

Tag Archives for " SQL "

PeopleSoft Security Tables

List of important PeopleSoft security tables that you can use to run queries & write SQLs to quickly extract information.

What are Authorized Actions in PSAUTHITEM table?

Authorized Actions in PSAUTHITEM table may have several values. All these values represent the permissions that are allowed on a component/page by the particular permission list.

Find Roles and Permission Lists that Grant Access to a Page

One of the most common security request is to identify who has access to a page and which role is granting that access. Here is the SQL to do that.

Find PeopleSoft queries a user has access to [SQL]

Wondering how to get a list of all the PeopleSoft queries that a user has access to? You probably know that access to the PeopleSoft query is controlled at several levels, so here are a few things you have to check. Does the user have access to query viewer or query manager? Does the user […]

Find Distribution List for a PeopleSoft process [SQL]

Who can access a report from PeopleSoft report manager ? or Who is getting the reports emailed out to them ? This is what is defined by the distribution list for each scheduled process. Find this information quickly in PeopleSoft.

1 2 3 4 Next »