From: Carlos Moreno <moreno_pg@mochima.com>
To: ramachandra.bhaskaram@wipro.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Providing user based previleges to Postgres DB
Date: Mon, 02 Apr 2007 10:42:13 -0400
Message-ID: <46111645.2050505@mochima.com> (raw)
In-Reply-To: <47230CE166B64744B0120173E4C2161EED84AC@BLR-EC-MBX01.wipro.com>
References: <20070402081739.696D19FB609@postgresql.org>
<20070402074519.GC1382@andi-lap.la.revver.com>
<47230CE166B64744B0120173E4C2161EED84AC@BLR-EC-MBX01.wipro.com>
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
--
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: moreno_pg@mochima.com, ramachandra.bhaskaram@wipro.com
Subject: Re: Providing user based previleges to Postgres DB
In-Reply-To: <46111645.2050505@mochima.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox