Oracle Database User "ANY" privileges for Pega Installation

General
, , , ,
1

Hi Team ,

We are referring to below deployment guide.

On this link its mentioned that Configure required deployment user privileges and roles. it is mentioned that Deployment user and Admin user will require “ANY” privileges For Ex instead of CREATE TABLE , It will require CREATE ANY TABLE.

As “ANY” privileges provides the access on other schemas too. Can anyone explain that why ANY privileges are required ? Also , Is it possible to continue without ANY privileges ?

Below are the privileges mentioned in the installation guide.

CREATE ANY TABLE

ALTER ANY TABLE

INSERT ANY TABLE WITH ADMIN OPTION

SELECT ANY TABLE

UPDATE ANY TABLE

DELETE ANY TABLE

CREATE ANY INDEX

CREATE ANY PROCEDURE

EXECUTE ANY PROCEDURE

CREATE ANY VIEW

CREATE ANY TYPE

CREATE ANY TRIGGER

ALTER ANY TRIGGER

GRANT ANY OBJECT PRIVILEGE

DROP ANY PROCEDURE

DROP ANY TRIGGER

DROP ANY TABLE

DROP ANY VIEW

DROP ANY INDEX

ANALYZE ANY

ANALYZE ANY DICTIONARY

Thanks
Sachin

2

@Mr.Sachin this question has been asked by others in the past, and unfortunately there is no way around it, the ANY access is required, as outlined in another recent post.