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.