title: How to exclude 'UNLIMITED TABLESPACE' from 'RESOURCE' privilege in Oracle
body: <p>After I create the user TEMP_USER with default and temp tablespace, then I grant the user with following </p>
  
  <pre><code>GRANT CONNECT TO TEMP_USER;
  GRANT RESOURCE TO TEMP_USER;
  GRANT CREATE ANY VIEW TO TEMP_USER;
  GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO TEMP_USER;
  GRANT advisor to TEMP_USER;
  GRANT administer sql tuning set to TEMP_USER;
  GRANT CREATE MATERIALIZED VIEW to TEMP_USER;
  </code></pre>
  
  <p>Then when execute </p>
  
  <pre><code>select * from session_privs;
  </code></pre>
  
  <p>I get all these privileges to current user:</p>
  
  <pre><code>CREATE SESSION
  UNLIMITED TABLESPACE
  CREATE TABLE
  CREATE CLUSTER
  CREATE ANY VIEW
  CREATE SEQUENCE
  CREATE PROCEDURE
  CREATE TRIGGER
  CREATE MATERIALIZED VIEW
  CREATE TYPE
  CREATE OPERATOR
  CREATE INDEXTYPE
  ADVISOR
  ADMINISTER SQL TUNING SET
  </code></pre>
  
  <p>and the <code>UNLIMITED TABLESPACE</code> is what I want this user to escape from, I know I can run revoke to remove the privilege, how can we exclude such privilege from <code>RESOURCE</code>, so that my user cannot access table with same name on other SCHEMA?</p>