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)
Список
Дерево обсуждения
Prevent users to drop triggers applied on table dipti shah <shahdipti1980@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 dipti shah <shahdipti1980@gmail.com>
Re: Prevent users to drop triggers applied on table Alban Hertroys <dalroi@solfertje.student.utwente.nl>
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
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: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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления
