Question
Accenture Services Pvt Ltd
IN
Last activity: 24 May 2017 10:49 EDT
User privileges to run pega for split schema
Hi,
We will build Pega7 environment with split schema. Pegadata is the dataschema and Pegarules is the rules schema. As per client policy we can't use dataschema in PegaRULES datasource. For that they have provided a separate user PgeaAppUser to use. Now can you please confirm what all privileges and grants we have to provide to this PegaAppUser so that application works fine. This will be a single user configuration.
As per installation guide do we need to provide all privileges that are mentioned for Base USer+Admin user to PegaAppUser?
Or only providing Base user privileges to PegaAppUser will be fine?
Our database is oracle.
PEG
GB
I've run under this configuration before.
If you need to connect to the database using a non-dataschema user then I believe you will need to grant execute any to that user.
I also had to grant select any table in order to get the SPPR_SYS_GETINDEXTIME to run.
Pegasystems Inc.
US
You do not need to grant "any" privileges to the base user. You can explicitly grant insert/update/delete/select/execute privileges to everything in the data and rules schemas.