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

Re: Limiting user access to a view only

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Richard Colman" <colman(at)uci(dot)edu>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Limiting user access to a view only
Date: 2004-05-05 17:10:26
Message-ID: 200405051910.26469.peter_e@gmx.net (view raw or flat)
Thread:
Lists: pgsql-admin
Richard Colman wrote:
> How would I set up a new user on PostgreSQL so that the new user is
> limited to reading a particular view, and can do nothing else.

A new user normally can't do anything.  Just grant the privileges on the 
view to him.  You may also want to revoke all permissions on databases 
and schemas, some of which are set to allow everything by default.  The 
GRANT manual page contains more information and pointers.



In response to

pgsql-admin by date

Next:From: Chris GamacheDate: 2004-05-05 20:03:55
Subject: Postmaster hogs CPU
Previous:From: Gaetano MendolaDate: 2004-05-05 16:27:41
Subject: Re: Limiting user access to a view only

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