Question
Apple Inc
US
Last activity: 2 Jul 2018 13:06 EDT
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
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
Accepted Solution
Pegasystems Inc.
IN
Hi Guarav,
In the deployment guide you can see that you will have a user which will be responsible for creating all the tables in PegaRules and PegaData schema.
Admin user needs the privilege to create a tables in PegaData schema.
So you need to give this "ANY" privilege to the Admin user.
Regards,
Vikash