Re: Permissions issue? - Mailing list pgsql-general

From Christopher Murtagh
Subject Re: Permissions issue?
Date
Msg-id 1071692998.6918.6.camel@brahma.wcg.mcgill.ca
Whole thread Raw
In response to Re: Permissions issue?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, 2003-12-17 at 15:25, Tom Lane wrote:
> Christopher Murtagh <christopher.murtagh@mcgill.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

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Permissions issue?
Next
From: Larry Rosenman
Date:
Subject: Re: bind-dlz with postgresql driver ...