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;
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