PeopleSoft Security Tables
List of important PeopleSoft security tables that you can use to run queries & write SQLs to quickly extract information.
Continue reading
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.
Continue reading
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.
Continue reading
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 […]
Continue reading
Resolved: Missing Action Drop Down on Voucher Mass Maintenance Page
When user tries to run Voucher Mass Maintenance, Action dropdown & Run button isn’t visible. It’s happening due to the missing security configuration.
Continue reading