Re: Proposal: Change of pg_trigger.tg_enabled and adding - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Proposal: Change of pg_trigger.tg_enabled and adding
Date
Msg-id 29631.1169849350@sss.pgh.pa.us
Whole thread Raw
In response to Re: Proposal: Change of pg_trigger.tg_enabled and adding  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: Proposal: Change of pg_trigger.tg_enabled and adding
Re: Proposal: Change of pg_trigger.tg_enabled and adding
List pgsql-hackers
Jan Wieck <JanWieck@Yahoo.com> writes:
> On 1/26/2007 4:40 PM, Jim Nasby wrote:
>> It would be nice if we had a separate role for replication services  
>> so that we weren't exposing superuser so much.

> So you think about another flag in pg_shadow? Would work for me.

How exactly would such a role differ from a "regular" superuser?  It
would still need an awful lot of privilege bypassing ability.  I'm
pretty dubious that you could lock it down enough to make it worth the
trouble of supporting an additional concept.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposal: Change of pg_trigger.tg_enabled and adding
Next
From: Rick Gigger
Date:
Subject: Re: 10 weeks to feature freeze (Pending Work)