In order to run PITSS.CON, many grants are required to be given to each PITSS user. This article contains all the necessary grants for PITSS.CON. Without these grants, PITSS.CON will not be able to run correctly which could result in either installation or runtime errors. In additional, in order to install users for PITSS.CON, the database user(s) must have the following privileges:
Roles:
- GRANT CONNECT TO &NEW_USER;
- GRANT CTXAPP TO &NEW_USER;
- GRANT RESOURCE TO &NEW_USER;
- GRANT SELECT_CATALOG_ROLE TO &NEW_USER;
- ALTER USER &NEW_USER DEFAULT ROLE CTXAPP, CONNECT, SELECT_CATALOG_ROLE;
System Privileges:
- GRANT ALTER SESSION TO &NEW_USER;
- GRANT CREATE PROCEDURE TO &NEW_USER;
- GRANT CREATE PUBLIC SYNONYM TO &NEW_USER;
- GRANT CREATE SEQUENCE TO &NEW_USER;
- GRANT CREATE SESSION TO &NEW_USER;
- GRANT CREATE SYNONYM TO &NEW_USER;
- GRANT CREATE TABLE TO &NEW_USER;
- GRANT CREATE TRIGGER TO &NEW_USER;
- GRANT CREATE TYPE TO &NEW_USER;
- GRANT CREATE VIEW TO &NEW_USER;
- GRANT DROP PUBLIC SYNONYM TO &NEW_USER;
- GRANT QUERY REWRITE TO &NEW_USER;
- GRANT SELECT ANY DICTIONARY TO &NEW_USER;
- GRANT UNLIMITED TABLESPACE TO &NEW_USER;
Object Privileges:
- GRANT SELECT ON CTXSYS.dr$parameter TO $NEW_USER;
- GRANT SELECT ON v_$session TO &NEW_USER;
- GRANT SELECT ON v_$database TO &NEW_USER;
- GRANT SELECT ON dba_objects TO &NEW_USER;
Learn more on how PITSS.CON can help you with your digital transformation needs : https://pitss.com/products/pitss-con
