Postgres Pro
Downloads
Home   >   mailing lists

Thread: SELECT privilege to a DATABASE

SELECT privilege to a DATABASE

From
Abhijit Gharami
Date:
Hi,

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.

Thanks and Regards,
Abhijit

Re: SELECT privilege to a DATABASE

From
Albe Laurenz
Date:
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