Postgres Pro
Downloads
Home   >   mailing lists

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

From Charles Clavadetscher
Subject RE: Remove default privilege from DB
Date
Msg-id 09ca01d3a3e0$685ca460$3915ed20$@swisspug.org
Whole thread Raw
In response to Remove default privilege from DB  (Durumdara <durumdara@gmail.com>)
Responses Re: Remove default privilege from DB  (Durumdara <durumdara@gmail.com>)
List pgsql-general
Tree view

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

 

Thank you for it!

 

Best regards

  DD

 

 

pgsql-general by date:

Previous
From: Durumdara
Date:
Subject: Remove default privilege from DB
Next
From: PegoraroF10
Date:
Subject: Re: execute block like Firebird does