Re: user space function "is_power_user"

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: hlinnaka(at)iki(dot)fi
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: user space function "is_power_user"
Date: 2015-06-22 09:22:33
Message-ID: CAFj8pRADUygh9z9Lef7y_t1qinCFYhoDDTiO03rnCkG_-NFSug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2015-06-22 11:20 GMT+02:00 Heikki Linnakangas <hlinnaka(at)iki(dot)fi>:

> On 06/22/2015 09:51 AM, Pavel Stehule wrote:
>
>> Hi
>>
>> I often need a function for identification if current user is database
>> owner or is superuser.
>>
>> It can be pretty simply implemented in C level.
>>
>> Do you think it should be available in core?
>>
>
> current_setting('is_superuser');
>

there is second constraint

OR "is database owner"

Pavel

>
> - Heikki
>
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2015-06-22 13:51:11 Re: Extension support for postgres_fdw
Previous Message Heikki Linnakangas 2015-06-22 09:20:41 Re: user space function "is_power_user"