Re: Remove default privilege from DB - Mailing list pgsql-general

Hi

 

From: Durumdara [mailto:durumdara@gmail.com]
Sent: Montag, 12. Februar 2018 09:32
To: Postgres General <pgsql-general@postgresql.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