title: Unable to grant DROP privilege on table to a role in Oracle database
body: <p>I am trying to grant DROP privilege to a role with statement &quot;GRANT DROP ON TABLE_NAME TO MY_ROLE_NAME&quot;.
  But iam getting &quot;missing or invalid privilege&quot; error. I  have logged in as schema user to grant DROP privilege.</p>
  <p>Can some one help me understand if it is syntax error or access issue or some other issue.</p>