From: Thomas Swan <tswan-lst@ics.olemiss.edu>
To: Steve Brett <steve.brett@e-mis.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Granting database level permissions...
Date: Fri, 26 Oct 2001 14:58:56 -0500
Message-ID: <3BD9C080.2070008@ics.olemiss.edu> (raw)
References: <3BCF3146.4090504@olemiss.edu>
<9qool6$1dj8$1@news.tht.net>
> Steve Brett wrote:
>
>have a look at pg_hba.conf in your data dir. it's all in there.
>
>Steve
>
>"Thomas Swan" <tswan@olemiss.edu> wrote in message
>news:3BCF3146.4090504@olemiss.edu...
>
>>Is it possible to grant database level access to a user in PostgreSQL?
>>
>>I have created a user and database, and I want the user to have full
>>control over that database. I have been through the online docs and
>>news groups but have not found a statement or answer to the question.
>>
>>Thomas
>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>>
The problem is not in access to psql. pg_hba.conf only controls that
portion or controls access to a database if a local user.
I want to do the equivalent of a
GRANT ALL on {database_name} TO {username};
If I want to allow a user to create a table on the database, I cannot
do that and restrict them only to the specified database. Currently
they would have to have created the database to have full rights on it.
Besides, if I want to have two users have full rights on a database, I
can't do that if I can only have one owner...
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-sql@postgresql.org
Cc: tswan-lst@ics.olemiss.edu, steve.brett@e-mis.com
Subject: Re: Granting database level permissions...
In-Reply-To: <3BD9C080.2070008@ics.olemiss.edu>
* 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