Re: checking if user is connected as a superuser?

From: Alvaro Herrera <alvherre(at)surnet(dot)cl>
To: Dragan Matic <mlists(at)panforma(dot)co(dot)yu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: checking if user is connected as a superuser?
Date: 2005-06-07 17:25:43
Message-ID: 20050607172543.GF17902@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Jun 06, 2005 at 12:21:56PM +0200, Dragan Matic wrote:
> Is there a way to check if user is a superuser for the given cluster?

alvherre=# show is_superuser;
is_superuser
--------------
on
(1 fila)

alvherre=# select current_setting('is_superuser');
current_setting
-----------------
on
(1 fila)

--
Alvaro Herrera (<alvherre[a]surnet.cl>)
La web junta la gente porque no importa que clase de mutante sexual seas,
tienes millones de posibles parejas. Pon "buscar gente que tengan sexo con
ciervos incendiándose", y el computador dirá "especifique el tipo de ciervo"
(Jason Alexander)

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Eduardo Bezerra 2005-06-07 17:36:56 btree information
Previous Message Glenn Sullivan 2005-06-07 16:30:09 Windows XP Service startup