Database Administration (MOSC)

MOSC Banner

DROP Partition of non owned schema

edited Sep 10, 2015 10:08AM in Database Administration (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center