Is it possible to grant a drop privilege on certain table on schema A to schema B ? Example in schema A, I have table EMP and I want to grant drop privilege on this EMP table to schema B, so that schema B can drop table EMP. I don't wan to grant drop any table privilege as this quite dangerous.