Re: Schema w/o alter table privs.

vwp914_at_aol.com (VWP914) wrote in message news:<20020203213259.12880.00000923_at_mb-mk.aol.com>...
> 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

If The User has created the Table then u will not be able to Avoid Him Making Alterations to the Table... Until He is the owner he is the ruler...

If not then u just have to revoke the resource and Create Table Privs and automatically he will not be able to Create or alter it.

regards,
Ganesh R Received on Mon Feb 04 2002 - 01:19:49 CST