PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Grant statements in the Build Script from Peoplesoft App designer

Hello dear community members,


we have a requirement in which we would like to grant access whenever a view is build or recreated from Peoplesoft App designer. For example whenever a particular view (eg: NY_XYZ_VW) is built within app designer, in the build script that gets generated we would like to have as a part of that script the "Grant Select On PS_NY_XYZ_VW to user ABC" statement also executed.


we do not want this to happen for every record but just a few selected records. Is there any setting on records or app designer that we can use to achieve this. Please shed some light on possible ways we can achieve this.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center