checking if user is connected as a superuser?

Поиск
Список
Период
Сортировка
Искать

checking if user is connected as a superuser?

От:
Dragan Matic <mlists@panforma.co.yu>
Дата:
Is there a way to check if user is a superuser for the given cluster?
Thanks in advance

Dragan

Re: checking if user is connected as a superuser?

От:
hubert depesz lubaczewski <depesz@gmail.com>
Дата:
On 6/6/05, Dragan Matic <mlists@panforma.co.yu> wrote:
Is there a way to check if user is a superuser for the given cluster?
Thanks in advance

select usesuper from pg_user where usename = CURRENT_USER;

depesz

Re: checking if user is connected as a superuser?

От:
Alvaro Herrera <alvherre@surnet.cl>
Дата:
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 ()
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)
FAQ