title: How to resolve ORA-1031: insufficient privileges for altering tablespace
body: <p>I am trying to change the tablespace on my user and what i am getting is insufficien privileges.Does anybody know how to solve this problem?
   Example:</p>
  
  <pre><code>SQL&gt; alter user test_
    2  default tablespace users temporary tablespace temp
    3  quota 800M on users
    4  /
  alter user test_
  *
  ERROR at line 1:
  ORA-01031: insufficient privileges
  </code></pre>