Tuesday, July 8, 2014

TRIRIGA and Custom DB Permissions

FYI

If a customer wants to use TRIRIGA with custom permissions on their database.

TRIRIGA requires the tridata user to have all the permissions listed below in order to work correctly. Custom permissions are not supported.



GRANT ANALYZE ANY TO TRIDATA;
GRANT CREATE VIEW TO TRIDATA;
GRANT CREATE TABLE TO TRIDATA;
GRANT ALTER SESSION TO TRIDATA;
GRANT CREATE SESSION TO TRIDATA;
GRANT CREATE SYNONYM TO TRIDATA;
GRANT CREATE TRIGGER TO TRIDATA;
GRANT CREATE SEQUENCE TO TRIDATA;
GRANT CREATE PROCEDURE TO TRIDATA;
GRANT DROP PUBLIC SYNONYM TO TRIDATA;
GRANT UNLIMITED TABLESPACE TO TRIDATA;
GRANT CREATE PUBLIC SYNONYM TO TRIDATA;
GRANT CONNECT TO TRIDATA;
GRANT RESOURCE TO TRIDATA;
 
ALTER USER TRIDATA DEFAULT ROLE CONNECT, RESOURCE;

No comments:

Post a Comment