pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to identify users with super privilegies in postgress ?
6+ messages / 5 participants
[nested] [flat]
* How to identify users with super privilegies in postgress ?
@ 2018-03-08 17:35 marcos sr <msr.mailing@gmail.com>
0 siblings, 3 replies; 6+ messages in thread
From: marcos sr @ 2018-03-08 17:35 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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?
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [MASSMAIL]How to identify users with super privilegies in postgress ?
@ 2018-03-08 18:33 gilberto.castillo@etecsa.cu
parent: marcos sr <msr.mailing@gmail.com>
2 siblings, 1 reply; 6+ messages in thread
From: gilberto.castillo@etecsa.cu @ 2018-03-08 18:33 UTC (permalink / raw)
To: marcos sr <msr.mailing@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
On 2018-03-08 12:35, marcos sr 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?
You would must change the postgresql version 8.4 is very old.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [MASSMAIL]How to identify users with super privilegies in postgress ?
@ 2018-03-08 18:45 marcos sr <msr.mailing@gmail.com>
parent: gilberto.castillo@etecsa.cu
0 siblings, 0 replies; 6+ messages in thread
From: marcos sr @ 2018-03-08 18:45 UTC (permalink / raw)
To: gilberto.castillo@etecsa.cu; +Cc: pgsql-admin@lists.postgresql.org
I know, but is a 'legacy system". It will be updated in a few(or not so
fews...) months. I'm new on the company. But first i need to study more
postgress.
2018-03-08 15:33 GMT-03:00 <gilberto.castillo@etecsa.cu>:
> On 2018-03-08 12:35, marcos sr 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?
>>
>
> You would must change the postgresql version 8.4 is very old.
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: How to identify users with super privilegies in postgress ?
@ 2018-03-08 19:01 David G. Johnston <david.g.johnston@gmail.com>
parent: marcos sr <msr.mailing@gmail.com>
2 siblings, 0 replies; 6+ messages in thread
From: David G. Johnston @ 2018-03-08 19:01 UTC (permalink / raw)
To: marcos sr <msr.mailing@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On Thursday, March 8, 2018, 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?
>
>
https://www.postgresql.org/docs/8.4/static/view-pg-user.html
David J.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: How to identify users with super privilegies in postgress ?
@ 2018-03-09 05:14 Shreeyansh Dba <shreeyansh2014@gmail.com>
parent: marcos sr <msr.mailing@gmail.com>
2 siblings, 1 reply; 6+ messages in thread
From: Shreeyansh Dba @ 2018-03-09 05:14 UTC (permalink / raw)
To: marcos sr <msr.mailing@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
You can identify the user privileges by using "\du+" or querying pg_user
catalog table from Psql terminal.
<http://www.shreeyansh.com;
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?
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: How to identify users with super privilegies in postgress ?
@ 2018-03-09 16:17 ALEXANDER JOSE <aangelj@hotmail.com>
parent: Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: ALEXANDER JOSE @ 2018-03-09 16:17 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; marcos sr <msr.mailing@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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.
[https://docs.google.com/uc?export=download&id=1gGhoMTYjvHWLCZkro06CHfeV5B0i67aE&revid=0B0kMU...]<http://www.shreeyansh.com;
On Thu, Mar 8, 2018 at 11:05 PM, marcos sr <msr.mailing@gmail.com<mailto: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?
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2018-03-09 16:17 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-03-08 17:35 How to identify users with super privilegies in postgress ? marcos sr <msr.mailing@gmail.com>
2018-03-08 18:33 ` gilberto.castillo@etecsa.cu
2018-03-08 18:45 ` marcos sr <msr.mailing@gmail.com>
2018-03-08 19:01 ` David G. Johnston <david.g.johnston@gmail.com>
2018-03-09 05:14 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2018-03-09 16:17 ` ALEXANDER JOSE <aangelj@hotmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox