Schema w/o alter table privs.

Is it possible to create a schema that people can connect to, yet do not have the ability to alter the tables? We have a very "open" database working environment, but I am sick and tired of have certain people adding columns to tables w/o running it by the people it affects! It seems to me that once you are able to connect, you are in effect logged in as the owner of the schema objects and can do whatever you want with them. Is there any way of ensuring that people can't alter the tables when they are logged in to a certain schema?

Any help would be appreciated.

Thomas Received on Sun Feb 03 2002 - 20:32:59 CST