5 Replies Latest reply: Nov 23, 2010 8:54 AM by sb92075 RSS

    ora-01031

    804603
      I try update on packages and produce this error ora.01031 insufficient privileges the user is rol dba
      i grant this privilegies but the error continue, i don't know do.
      GRANT CREATE LIBRARY TO user;
      GRANT CREATE MATERIALIZED VIEW to user;
      GRANT CREATE JOB to user;
      GRANT CREATE PROCEDURE to user;
      GRANT CREATE PUBLIC SYNONYM to user;
      GRANT CREATE SEQUENCE to user;
      GRANT CREATE SESSION to user;
      GRANT CREATE SYNONYM to user;
      GRANT CREATE TABLE to user;
      GRANT CREATE TRIGGER to user;
      GRANT CREATE USER to user;
      GRANT CREATE VIEW to user;
      GRANT EXECUTE ANY LIBRARY to user;
      GRANT EXECUTE ANY PROCEDURE to user;
      GRANT EXECUTE ANY PROGRAM to user;
      GRANT SELECT ANY DICTIONARY to user;
      GRANT SELECT ANY SEQUENCE to user;
      GRANT SELECT ANY TABLE to user;
      GRANT UNLIMITED TABLESPACE to user;
      GRANT UPDATE ANY TABLE to user;
      GRANT UPDATE ANY PACKAGE to user;
      grant dba to user;