Search Postgresql Archives

Re: Default Privilege Table ANY ROLE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Default Privilege Table ANY ROLE
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Wed, 14 Nov 2018 15:53:39 -0500
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
Comments: In-reply-to Nicolas Paris <nicolas.paris@xxxxxxxxxx> message dated "Wed, 14 Nov 2018 21:23:00 +0100"
In-reply-to: <20181114202055.a23bgy354qnmo7jn@riseup.net>
References: <20181114141608.ryvolxl7v7z2grzi@riseup.net> <306e4be880a264c701be5dfa667a1e95de76e175.camel@cybertec.at> <20181114202055.a23bgy354qnmo7jn@riseup.net>

Maybe I'm missing something, but doesn't this solve your problem
as stated?

ALTER DEFAULT PRIVILEGES IN SCHEMA myschema GRANT SELECT ON TABLES TO public;

			regards, tom lane

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Default Privilege Table ANY ROLE
  - From: Stephen Frost
- Re: Default Privilege Table ANY ROLE
  - From: Nicolas Paris

References:
- Default Privilege Table ANY ROLE
  - From: Nicolas Paris
- Re: Default Privilege Table ANY ROLE
  - From: Laurenz Albe
- Re: Default Privilege Table ANY ROLE
  - From: Nicolas Paris

Prev by Date: Re: pg_dump out of memory for large table with LOB
Next by Date: Re: pg_dump out of memory for large table with LOB
Previous by thread: Re: Default Privilege Table ANY ROLE
Next by thread: Re: Default Privilege Table ANY ROLE
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux