Re: Drop Default Privileges? - Mailing list pgsql-general

From Victor Yegorov
Subject Re: Drop Default Privileges?
Date
Msg-id CAGnEboiYLFrieaNfxOcUtobEwy0f=05MiGgW4fv187NWmE4d_g@mail.gmail.com
Whole thread Raw
In response to Re: Drop Default Privileges?  (Pavan Teja <pavan.postgresdba@gmail.com>)
List pgsql-general
вт, 19 июн. 2018 г. в 21:32, Pavan Teja <pavan.postgresdba@gmail.com>:
In order to remove the default privileges for any particular user/role, we should know the list of default privileges. 

`psql` allows you to check default privileges via `\ddp` command (per database). You can start `psql` with `-E` switch that will show you internal queries used for displaying this information, or you can `\set ECHO_HIDDEN on` with the same effect.

Also, you can do `pg_dumpall -s | grep -E 'DEFAULT PRIVILEGE|\\connect' and it'll produce a list of all entries for all databases, along with database name.


--
Victor Yegorov

pgsql-general by date:

Previous
From: Pavan Teja
Date:
Subject: Re: Drop Default Privileges?
Next
From: Victor Yegorov
Date:
Subject: Re: Drop Default Privileges?