pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Granting database level permissions...
3+ messages / 3 participants
[nested] [flat]

* Granting database level permissions...
@ 2001-10-18 19:45  Thomas Swan <tswan@olemiss.edu>
  0 siblings, 1 reply; 3+ messages in thread

From: Thomas Swan @ 2001-10-18 19:45 UTC (permalink / raw)
  To: pgsql-sql

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





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Granting database level permissions...
@ 2001-10-19 08:32  Steve Brett <steve.brett@e-mis.com>
  parent: Thomas Swan <tswan@olemiss.edu>
  0 siblings, 1 reply; 3+ messages in thread

From: Steve Brett @ 2001-10-19 08:32 UTC (permalink / raw)
  To: pgsql-sql

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





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Granting database level permissions...
@ 2001-10-26 19:58  Thomas Swan <tswan-lst@ics.olemiss.edu>
  parent: Steve Brett <steve.brett@e-mis.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Thomas Swan @ 2001-10-26 19:58 UTC (permalink / raw)
  To: Steve Brett <steve.brett@e-mis.com>; +Cc: pgsql-sql

> 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...





^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2001-10-26 19:58 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-10-18 19:45 Granting database level permissions... Thomas Swan <tswan@olemiss.edu>
2001-10-19 08:32 ` Steve Brett <steve.brett@e-mis.com>
2001-10-26 19:58   ` Thomas Swan <tswan-lst@ics.olemiss.edu>

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