Originally posted by: SystemAdmin
While trying to run the m4ora8.sql (Trigger Installation) script in a source Database for DataStage TX I get the following errors:
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SYS_SQL", line 826
ORA-06512: at "SYS.DBMS_SQL", line 39
ORA-06512: at line 23
ORA-06512: at line 288
The user has all the privileges that the script require:
1. EXECUTE privilege on DBMS_ALERT
-
(e.g. GRANT EXECUTE ON DBMS_ALERT TO ASCENTIAL).
-
2. EXECUTE privilege on DBMS_SQL
-
(e.g. GRANT EXECUTE ON DBMS_SQL TO ASCENTIAL).
-
3. CREATE ANY TRIGGER system privilege
-
(e.g. GRANT CREATE ANY TRIGGER TO ASCENTIAL).
-
4. DROP ANY TRIGGER system privilege
-
(e.g. GRANT DROP ANY TRIGGER TO ASCENTIAL).
-
5. CREATE PUBLIC SYNONYM privilege
-
e.g. GRANT CREATE PUBLIC SYNONYM TO ASCENTIAL).
-
6. DROP PUBLIC SYNONYM privilege
-
e.g. GRANT DROP PUBLIC SYNONYM TO ASCENTIAL).
but the error persists.
Hope you can help
Fernando Romero
#DataExchange#IBMSterlingTransformationExtender#IBM-Websphere-Transformation-Extender