Question

1
Replies
181
Views
GauravS9130 Member since 2018 8 posts
Apple Inc
Posted: 2 years ago
Last activity: 2 years 3 months ago
Closed
Solved

Oracle "ANY" privileges for Deployment and Admin user

Hi Team ,

We are referring to below deployment guide.

https://community.pega.com/system/files/pdfs/Pega74-install-tomcat-orac…

On Page 14, 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

Gaurav

Low-Code App Development Installation and Deployment Data Integration
Moderation Team has archived post
Share this page LinkedIn