RE: Remove default privilege from DB

Hi

From: Durumdara [mailto:durumdara(at)gmail(dot)com]
Sent: Montag, 12. Februar 2018 09:32
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Remove default privilege from DB

Hello!

I need to remove default privileges from a Database.

After that some of them remains.

Default access privileges

Owner | Schema | Type | Access privileges

------------+--------+----------+-------------------

postgres | | function | =X/postgres

postgres | | sequence |

postgres | | table |

postgres | | type | =U/postgres

suser | | function | =X/suser

suser | | sequence |

suser | | table |

suser | | type | =U/suser

How to completely remove the last items?

Could you send me one example?

I assume

ALTER DEFAULT PRIVILEGES FOR ROLE suser REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC;

ALTER DEFAULT PRIVILEGES FOR ROLE suser REVOKE USAGE ON TYPE FROM PUBLIC;

Bye

Charles

Thank you for it!

Best regards

DD