title: Restrict DROP and ALTER table under specific schema in Oracle
body: <p>I have created a user (say DROP_PARTITION_USER) to drop partitions of a table. The table is owned by different user (say NORMAL_USER).
  Currently, I have granted <strong>DROP ANY TABLE</strong> and <strong>ALTER ANY TABLE</strong> privileges to DROP_PARTITION_USER. When DROP_PARTITION_USER executes following statement, it gets executed successfully. </p>
  
  <pre><code>ALTER TABLE SCHEMANAME.TABLENAME DROP PARTITION &lt;PARTITION_NAME&gt; UPDATE GLOBAL INDEXES;
  </code></pre>
  
  <p>But, <strong>DROP ANY TABLE</strong> and <strong>ALTER ANY TABLE</strong>  allows DROP_PARTITION_USER to drop and alter any table under any schema [<a href="https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9013.htm" rel="nofollow noreferrer">https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9013.htm</a> ]. 
  Is there any way in Oracle to restrict drop and alter table under specific schema?</p>