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 <pierce@xxxxxxxxxxxx> wrote:
dipti shah wrote: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.
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.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
