Re: Can I check if somebody is superuser in stored procedure? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Can I check if somebody is superuser in stored procedure?
Date
Msg-id 1302117188.14384.4.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: Can I check if somebody is superuser in stored procedure?  (Jim Nasby <jim@nasby.net>)
List pgsql-hackers
On ons, 2011-04-06 at 09:51 -0500, Jim Nasby wrote:
> Note that doesn't work if the user has superuser because it was granted via another role.

You can only be a superuser if your own superuser bit is set.  It cannot
be granted via some other role.  (Not sure whether that's a feature.)



pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Should psql support URI syntax?
Next
From: Dan Ports
Date:
Subject: Re: getting to beta