Question

1
Replies
204
Views
Close popover
Gaurav Srivastava (GauravS9130)
Apple Inc

Apple Inc
US
GauravS9130 Member since 2018 8 posts
Apple Inc
Posted: June 20, 2018
Last activity: July 2, 2018
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-oracle_1.pdf

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

System Administration Installation and Deployment Data Integration
Moderation Team has archived post