Database Administration (MOSC)

MOSC Banner

Is it possible to revoke alter table permissions from a schema owner?

edited May 19, 2017 1:43PM in Database Administration (MOSC) 9 commentsAnswered ✓

In the past a nightmare was created.  A previous administration allowed an application to use the schema owner to connect.  Now someone is using that account to alter the structures.  Can I revoke permissions such as alter table, drop and create from a schema owner account?  If so, how do I do it?

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