Question

8
Replies
520
Views
Close popover
Sayantan Chowdhury (SayantanC3655)
Capgemini
Lead System Architect
Capgemini
IN
SayantanC3655 Member since 2017 4 posts
Capgemini
Posted: March 8, 2018
Last activity: March 23, 2018
Closed

Need query to grant privileges to 'Base User' per object_type in a Dual User setup

Hi,

We are trying to use Dual User configuration in Pega 7.3.1 with WebSphere/Oracle. When it comes to the Base User we have the following line mentioned in Installation Guide - "Basic read and write access to data and rules tables including rules resolution."

I understand it is advised to provide insert/update/delete/execute on the objects within the data and rules schemas for Base User - could someone please be specific for each object_types under the schemas ?

For example,

select count(*) , object_type, owner from dba_objects where owner like 'XXX%' group by object_type, owner order by owner ;

COUNT(*) OBJECT_TYPE OWNER
---------- ----------------------- ----------------------------
1 LOB XXX_ADMIN
6 FUNCTION XXX_APP_DATA
657 INDEX XXX_APP_DATA
20 JAVA CLASS XXX_APP_DATA
159 LOB XXX_APP_DATA
9 PROCEDURE XXX_APP_DATA
289 TABLE XXX_APP_DATA
3 VIEW XXX_APP_DATA
6 FUNCTION XXX_APP_RULES
324 INDEX XXX_APP_RULES
20 JAVA CLASS XXX_APP_RULES
40 LOB XXX_APP_RULES
1 PROCEDURE XXX_APP_RULES
66 TABLE XXX_APP_RULES
3 VIEW XXX_APP_RULES

15 rows selected.

  1. Could someone please provide me the exact query to be run to grant privileges to 'Base User' ? Please specify on each type of object_types.
  2. Should it be granted through roles ?

Thanks!

System Administration Installation and Deployment Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.