Postgres Pro
Downloads
Home   >   mailing lists

readonly acces to a db - Mailing list pgsql-admin

From Stefan Scherf
Subject readonly acces to a db
Date
Msg-id NCBBKJOCIJFOPDBCOJOIKEJKEOAA.scherf@ventasoft.de
Whole thread Raw
List pgsql-admin
Tree view 
Hi,

I have an user "tom" and a database "info". Now I want to allow tom to
connect to info, but he should only have read access (SELECT). This
especially means, that he should not be allowed to create tables or other
objects.

How can I manage this?

Greetings

Stefan

pgsql-admin by date:

Previous
From: matthew.copeland@honeywell.com
Date:
Subject: ERROR: Conditional NOTIFY is not implemented
Next
From: "C. Bensend"
Date:
Subject: Restricting user -> database access.