DROP Partition of non owned schema
Hi,
I have 2 schema s.
Schema A has a table named T1 and has partitions PART012015, PART022015, PART032015
Schema B need privilege to drop A.T1 partitions.
Without giving DROP ANY TABLE privilege is there any privilege where I can give targeting only specific table. A.T1.
According to the security standard providing DROP ANY TABLE to user B will gain the schema B to drop any tables in all schema, how can I avoid this.