Question
Nomura Research Institute
JP
Last activity: 10 Nov 2017 7:29 EST
Normal user privileges after deployment
Hi,
I'm planning to install Pega 7.2.2, running on Tomcat and Oracle DB (single-schema).
After deployment, I wonder how I should set normal users' privileges.
I think these users can use application if they have select/insert/update/delete privileges,
but the install manual of Pega 7.2.2 says I should grant some CREATE permissions to table, procedure, view, type and trigger.
Is this necessary set for normal user, using pega application for creating works or checking reports?
I want to confirm if I misunderstand or not, although this post (https://pdn.pega.com/community/product-support/question/user-privileges-run-pega-split-schema) might be related.
Pegasystems Inc.
IN
Hi There,
Creating Work or checking reports would be done by PRPC users like SampleUser@SampleApp whereas the Create and other grants discussed here are for DB user used for deploying and Install PRPC.
And for Single Schema installation, base user would need all the permission that of Admin users also.
Hope you find this useful :)
Regards,
Ujjwal
Nomura Research Institute
JP
> And for Single Schema installation, base user would need all the permission that of Admin users also.
I'm considering applying DDLs is done by manual (one DB user that has privileges such as CREATE/DROP/ALTER objects).
So I think the base user of Pega has no necessary for privileges as mentioned before. the user just has DML privileges such as SELECT/DELETE/UPDATE/INSERT.
In this case, should base user need all the permission that of Admin users also ?
Thanks,
Manabu
Pegasystems Inc.
IN
DB operation would be done by a particular DB user that you would configure Data-source with.
If you would attempt to create a new class group then the corresponding table would get created and hence DB user would require create privilege .