Skip site navigation (1) Skip section navigation (2)

Re: User Management

From: Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz>
To: Chris Cameron <chris(at)UpNIX(dot)com>
Cc: "D(dot) Duccini" <duccini(at)backpack(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: User Management
Date: 2001-07-05 09:13:14
Message-ID: 3B442FAA.6545E12@catalyst.net.nz (view raw or flat)
Thread:
Lists: pgsql-novice
Chris Cameron wrote:
> 
> This has been working well so far, thanks.
> 
> Um, looking at http://www.postgresql.org/idocs/index.php?privileges.html
> it seems to be that I'm not actually able to do what I want. Am I
> correct in believing that to let a user create tables and change tables
> in a database, they actually have to had created it? The best I can do
> is grant privileges on premade tables?

It's not as straightforward, but you should also be able to grant suitable
privileges on the metadata tables.  Use \dS to list the metadata tables.

Cheers,
					Andrew.
-- 
_____________________________________________________________________
           Andrew McMillan, e-mail: Andrew(at)catalyst(dot)net(dot)nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64(27)246-7091, Fax:+64(4)499-5596, Office: +64(4)499-2267xtn709

In response to

pgsql-novice by date

Next:From: Nabil SayeghDate: 2001-07-05 11:22:28
Subject: Re: User Management
Previous:From: Giorgio A.Date: 2001-07-05 09:09:29
Subject: Re: User Management

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group