Re: Prevent users to drop triggers applied on table

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.