Re: Permissions issue?

From: Christopher Murtagh <christopher(dot)murtagh(at)mcgill(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Permissions issue?
Date: 2003-12-17 20:29:59
Message-ID: 1071692998.6918.6.camel@brahma.wcg.mcgill.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2003-12-17 at 15:25, Tom Lane wrote:
> Christopher Murtagh <christopher(dot)murtagh(at)mcgill(dot)ca> writes:
> > Am I missing something obvious?
>
> The permissions were granted to PUBLIC, not to newuser, and so the
> REVOKE doesn't do anything. You'd need to revoke rights from PUBLIC and
> then grant them back to whomever should have them.

Ahhh. that's it! I was missing something obvious. Thanks for the clue!

Cheers,

Chris

--
Christopher Murtagh
Enterprise Systems Administrator
ISR / Web Communications Group
McGill University
Montreal, Quebec
Canada

Tel.: (514) 398-3122
Fax: (514) 398-2017

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Larry Rosenman 2003-12-17 20:35:31 Re: bind-dlz with postgresql driver ...
Previous Message Stephan Szabo 2003-12-17 20:28:35 Re: Permissions issue?