Re: How to identify users with super privilegies in postgress ?

Hi, other opction;

>psql

select * from pg_user where usesuper='TRUE';

Alexander Angel

DBA Postgresql

venezuela

________________________________
De: Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
Enviado: viernes, 09 de marzo de 2018 05:14 a.m.
Para: marcos sr
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Asunto: Re: How to identify users with super privilegies in postgress ?

You can identify the user privileges by using "\du+" or querying pg_user catalog table from Psql terminal.

[https://docs.google.com/uc?export=download&id=1gGhoMTYjvHWLCZkro06CHfeV5B0i67aE&revid=0B0kMUYo6rsLZRXpXakFESmpyK2NqbG5BOW9zakpWU2U3S3NjPQ]<http://www.shreeyansh.com>

On Thu, Mar 8, 2018 at 11:05 PM, marcos sr <msr(dot)mailing(at)gmail(dot)com<mailto:msr(dot)mailing(at)gmail(dot)com>> wrote:
Hello,

I'm new on postgress, I need verify if exists users with "super privileges" in postgress 8.4.

What commands should I run? And what files i need look?