Dear Charles! 2018-02-12 10:03 GMT+01:00 Charles Clavadetscher <clavadetsc...@swisspug.org >:
> 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 > After that: Default access privileges Owner | Schema | Type | Access privileges ------------+--------+----------+------------------- suser | | function | suser | | sequence | suser | | table | suser | | type | (4 rows) What are they? select * from pg_default_acl 24629;0;"r";"{}" 24629;0;"S";"{}" 24629;0;"f";"{}" 24629;0;"T";"{}" 24629 = suser | namespace 0 = none in document Hmmm... It's very strange for me. I don't find any point which links this user to this database. Do you have any idea? Thanks dd
