Database Administration (MOSC)

MOSC Banner

Granted priveleges to create(alter,drop,replace) for other schema`s objects

edited Nov 14, 2014 10:00AM in Database Administration (MOSC) 2 commentsAnswered


Hi friends!

I have a task to grant for user access to schema objects(another schema)

Practicaly he should have all rights on schema as schema owner.

But when he will be connecting he will be using own username(not the schema)

Its easy to grant permisions to select,update,execute,delete.

But there is a problem to grant permissions to create(alter,drop,replace) objects.

Oracle has system priveleges with word "any". This priveleges allow create(alter,drop,replace) objects not only in own and requiered schema but all schemas in DB.

But it is wrong. Is there the way to 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