Re: SELECT privilege to a DATABASE

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "'Abhijit Gharami *EXTERN*'" <abhijitgharami1(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: SELECT privilege to a DATABASE
Date: 2016-09-16 10:03:12
Message-ID: A737B7A37273E048B164557ADEF4A58B538B123C@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Abhijit Gharami wrote:
> How can we provide only SELECT privilege on all the table in a DATABASE to a user. I checked the
> documents and found that it is possible in schema level of a database.

No, you have to do it schema by schema.

Yours,
Laurenz Albe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas 2016-09-17 22:05:27 postgres create database command does not create database
Previous Message Abhijit Gharami 2016-09-16 05:22:52 SELECT privilege to a DATABASE