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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
