Hi
From: Durumdara [mailto:durumd...@gmail.com] Sent: Montag, 12. Februar 2018 09:32 To: Postgres General <pgsql-gene...@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 Thank you for it! Best regards DD
