Ask Question
Help Others
Home › Forums › PeopleSoft › PeopleSoft Technical

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.

data from the permission list that will show the level of access

1 reply [Last post]
Wed, 01/11/2012 - 1:41pm
Guest's picture
Guest

Hi All,
How to get the data from the permission list that will show the level of access (if any) to Application Designer.

Thanks a lot !!!

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
Top
  • Login to post comments
  • 2266 reads
Thu, 01/12/2012 - 4:20pm
#1
Lepa's picture
Lepa
User offline. Last seen 1 year 37 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: data from the permission list that will show the level ...

The below SQL will give you all permissions list that have Application Designer access.

SELECT DISTINCT CLASSID
FROM PSAUTHITEM
WHERE MENUNAME = 'APPLICATION_DESIGNER';

You will then need to navigate to the PeopleTools page on the permissions component to find the level of access. I'm sure they are stored on a table somewhere but never had the need to dive deeper than that.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Top