title: As a system user I have this error: ORA-01031: insufficient privileges
body: <p>I have a stored procedure for deleting partitions. Before starting, I have to delete a constraint.</p>
  
  <p>I installed the stored procedure on system user. When I test the procedure I have this error: <strong>'ORA-01031: insufficient privileges'</strong>.</p>
  
  <p>This is a piece of code that I wrote:</p>
  
  <pre><code>BEGIN
  
      EXECUTE IMMEDIATE 'ALTER TABLE USER_NAME.TABLE_NAME DISABLE CONSTRAINT CONSTRAINT_NAME';
  
  EXCEPTION
      WHEN OTHERS THEN
  
          O_sCodError := 'NO_OK';
          O_sDesError := 'Error at DISABLE CONSTRAINT_NAME: ' || SQLERRM || ';';
  
          RETURN;
  
  END;
  </code></pre>
  
  <p>Well, as I execute the stored procedure as system, I do not understand the reason for I have that error. And I think I eventually think the same error when I try to delete a partition.</p>