Skip site navigation (1) Skip section navigation (2)

readonly acces to a db

From: "Stefan Scherf" <scherf(at)ventasoft(dot)de>
To: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
Subject: readonly acces to a db
Date: 2001-08-21 21:46:15
Message-ID: NCBBKJOCIJFOPDBCOJOIKEJKEOAA.scherf@ventasoft.de (view raw or flat)
Thread:
Lists: pgsql-admin
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


Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2001-08-21 23:45:40
Subject: Re: ERROR: Conditional NOTIFY is not implemented
Previous:From: matthew.copelandDate: 2001-08-21 21:14:21
Subject: ERROR: Conditional NOTIFY is not implemented

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group