Message-ID: <46111645.2050505@mochima.com>
Date: Mon, 02 Apr 2007 10:42:13 -0400
From: Carlos Moreno <moreno_pg@mochima.com>
User-Agent: Thunderbird 1.5.0.10 (X11/20070301)
MIME-Version: 1.0
To: ramachandra.bhaskaram@wipro.com
CC: pgsql-performance@postgresql.org
Subject: Re: Providing user based previleges to Postgres DB
References: <20070402081739.696D19FB609@postgresql.org>
	<20070402074519.GC1382@andi-lap.la.revver.com>
	<47230CE166B64744B0120173E4C2161EED84AC@BLR-EC-MBX01.wipro.com>
In-Reply-To: <47230CE166B64744B0120173E4C2161EED84AC@BLR-EC-MBX01.wipro.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

ramachandra.bhaskaram@wipro.com wrote:
>
> Hi All,
>
>       Currently in one of the projects we want to restrict the 
> unauthorized users to the Postgres DB.    Here we are using Postgres 
> version 8.2.0
>
>       Can anybody tell me how can I provide the user based previleges 
> to the Postgres DB so that, we can restrict the unauthorized users as 
> well as porivde the access control to the users based on the set 
> previleges by the administrator.    
>

The pgsql-general list might be more appropriate for this type of
question...  Still:

Are you talking restrictions based on database-users ?   If so, look
up grant and revoke in the PG documentation  (under SQL commands).

If you're talking about restricting system-users to even attempt to use
psql  (which really, would not be much of a restriction), then perhaps
you would have to assign a group-owner to the file psql and grant
execute permission to the group only (well, and owner).

HTH,

Carlos
--