| From: | Victor Yegorov <vyegorov(at)gmail(dot)com> |
|---|---|
| To: | pavan(dot)postgresdba(at)gmail(dot)com |
| Cc: | louis(dot)battuello(at)etasseo(dot)com, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Drop Default Privileges? |
| Date: | 2018-06-19 18:40:04 |
| Message-ID: | CAGnEboiYLFrieaNfxOcUtobEwy0f=05MiGgW4fv187NWmE4d_g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
вт, 19 июн. 2018 г. в 21:32, Pavan Teja <pavan(dot)postgresdba(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Victor Yegorov | 2018-06-19 18:41:54 | Re: Drop Default Privileges? |
| Previous Message | Pavan Teja | 2018-06-19 18:31:34 | Re: Drop Default Privileges? |