title: How to grant quota on a temporary tablespace to a user
body: <p>I'm trying to create a user in Oracle 12c with a default temporary tablespace and with a quota for that tablespace.</p>
  
  <p>My statement is:</p>
  
  <pre><code>CREATE USER test_user2
  IDENTIFIED BY "pass1234"
  DEFAULT TABLESPACE TEMP_WORK_TS
  QUOTA 100M ON TEMP_WORK_TS
  QUOTA 100M ON TEMP_TEST_01
  TEMPORARY TABLESPACE TEMP_TEST_01
  PROFILE DEFAULT_PROFILE
  ACCOUNT UNLOCK; 
  </code></pre>
  
  <p>But I get error:</p>
  
  <blockquote>
    <p>ORA-30041: Cannot grant quota on the tablespace</p>
  </blockquote>
  
  <p>The <a href="https://docs.oracle.com/database/121/DBSEG/users.htm#DBSEG99778" rel="nofollow">Oracle documentation</a> shows a quota being assigned for a user's temporary tablespace.</p>
  
  <p>Why does my statement doing the same thing get that error?</p>