pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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...





view thread (3+ messages)

Message-ID: <3BD9C080.2070008@ics.olemiss.edu>
Permalink:  ../3BD9C080.2070008@ics.olemiss.edu/
Also on:    postgresql.org/message-id/3BD9C080.2070008@ics.olemiss.edu

 · 

reply

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