Question

8
Replies
498
Views
SayantanC3655 Member since 2017 4 posts
Capgemini
Posted: 2 years ago
Last activity: 2 years 7 months ago
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 Low-Code App Development Installation and Deployment Data Integration
Moderation Team has archived post
Share this page LinkedIn