Postgres Pro
Downloads
Home   >   mailing lists

Thread: user space function "is_power_user"

user space function "is_power_user"

From
Pavel Stehule
Date:
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?

Regards

Pavel

Re: user space function "is_power_user"

From
Heikki Linnakangas
Date:
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');

- Heikki

Re: user space function "is_power_user"

From
Pavel Stehule
Date:


2015-06-22 11:20 GMT+02:00 Heikki Linnakangas <hlinnaka@iki.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