Is it possible to revoke alter table permissions from a schema owner?
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?