Re: [GENERAL] Prevent users to drop triggers applied on table

2010-04-01 Thread Alban Hertroys
On 1 Apr 2010, at 9:52, dipti shah wrote: > 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 > thei

Re: [GENERAL] Prevent users to drop triggers applied on table

2010-04-01 Thread dipti shah
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,

Re: [GENERAL] Prevent users to drop triggers applied on table

2010-04-01 Thread John R Pierce
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. C

[GENERAL] Prevent users to drop triggers applied on table

2010-04-01 Thread dipti shah
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 sugge