Postgres Pro
Downloads
Home   >   mailing lists

Remove default privilege from DB - Mailing list pgsql-general

From Durumdara
Subject Remove default privilege from DB
Date
Msg-id CAEcMXhn2uWDFyQ=dLzeEhdoyuvqvgYaLnOZbVmY+g3oR_NKr3g@mail.gmail.com
Whole thread Raw
Responses RE: Remove default privilege from DB  ("Charles Clavadetscher" <clavadetscher@swisspug.org>)
List pgsql-general
Tree view
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?

Thank you for it!

Best regards
  DD


pgsql-general by date:

Previous
From: Sand Stone
Date:
Subject: Fwd: persistent read cache
Next
From: "Charles Clavadetscher"
Date:
Subject: RE: Remove default privilege from DB