Postgres Pro
Downloads
Home   >   mailing lists

Re: How to identify users with super privilegies in postgress ? - Mailing list pgsql-admin

From ALEXANDER JOSE
Subject Re: How to identify users with super privilegies in postgress ?
Date
Msg-id BN6PR15MB134803C8B3B7C19F56BE1453A5DE0@BN6PR15MB1348.namprd15.prod.outlook.com
Whole thread Raw
In response to Re: How to identify users with super privilegies in postgress ?  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
List pgsql-admin
Tree view

Hi, other opction;


>psql


select * from pg_user where usesuper='TRUE';

Alexander Angel

DBA Postgresql

venezuela


De: Shreeyansh Dba <shreeyansh2014@gmail.com>
Enviado: viernes, 09 de marzo de 2018 05:14 a.m.
Para: marcos sr
Cc: pgsql-admin@lists.postgresql.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.



On Thu, Mar 8, 2018 at 11:05 PM, marcos sr <msr.mailing@gmail.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?


pgsql-admin by date:

Previous
From: Shreeyansh Dba
Date:
Subject: Re: How to identify users with super privilegies in postgress ?
Next
From: ghiureai
Date:
Subject: streaming replication and wal 's usages