Re: Database Privileges

From: Alfonso Peniche <alfonso(at)iteso(dot)mx>
To:
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database Privileges
Date: 2001-01-17 16:21:41
Message-ID: 3A65C695.542409B3@iteso.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I think there's one possible solution, though I haven't fully tried it and
the administration can become rather bothersome and even complicated, but
here goes.

I did some testing by modifying the pg_hba.conf file, specifying which
database may be access from which IP address, and it worked, though I
haven't done any serious testing.

The reason this might work for me is that I don't have that many users to
connect directly to the database, instead I use a common user account,
which, in a multi-tier scheme, makes the connection from an App-server
(the App-server makes a remote connection to my pg-server), so I know
there's only one machine (besides mine), that would be connecting to the
database.

As I said before:
1.- If you have several connections from diferent machines this method
could become rather complicated, but it's an idea.
2.- I haven't fully tested it.

Hope this helps.

Alfonso Peniche

Markus Wigge wrote:

> Hi PG-Admins,
>
> I think this question is asked more often than you'd like it to be
> so excuse me ...
> Is there any possibility to restrict database-access user based?
> When I create a user without the permission to create databases this
> user has access to all available databases on the system. He can
> create and drop database objects but cannot manipulate objects owned
> by other users.
>
> I don't really like this situation and I want to give exclusive right
> to databases so that just the owner of it can create and drop
> things.
>
> --
> bye,
> Markus mailto:markus(at)cultcom(dot)de

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Markus Wigge 2001-01-17 17:31:40 Re[2]: Database Privileges
Previous Message R D 2001-01-17 15:52:11 Re: Database Privileges