Yah...that's correct but I am wondering if someone out there knows work around to this.
I could make my table owner to postgres user but then is there any way original user can drop the table. I want original users should allow to drop their table. Thanks, Dipti On Thu, Apr 1, 2010 at 12:58 PM, John R Pierce <pie...@hogranch.com> wrote: > dipti shah wrote: > >> Hi, >> >> We have been using a stored procedure which allow users to create table. >> The stored procedure creates actual table, logging tables, views, and >> applies triggers. I want to prevent table owner from deleting the triggers >> applied on table by create table stored procedure. Could anyone please >> suggest me to get way out here. >> > > if you don't want someone to modify tables, including dropping triggers, > then they shouldn't be the owner of it. the owner has full rights to a > table, including the right to delete it, alter it, etc. > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
