Re: Prevent users to drop triggers applied on table

Поиск
Список
Период
Сортировка
От dipti shah
Тема Re: Prevent users to drop triggers applied on table
Дата
Msg-id s2wd5b05a951004010052o9c3faca6j728f4a42789a3f4a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Prevent users to drop triggers applied on table  (John R Pierce <pierce@hogranch.com>)
Ответы Re: Prevent users to drop triggers applied on table  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Список pgsql-general
Дерево обсуждения
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 <pierce@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

В списке pgsql-general по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: "1-Click" installer problems
Следующее
От: John R Pierce
Дата:
Сообщение: Re: "1-Click" installer problems