Hi From: Durumdara [mailto:durumdara@xxxxxxxxx] 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 |
