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

Re: patch for type privileges

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Yeb Havinga <yebhavinga(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: patch for type privileges
Date: 2011-12-01 21:14:02
Message-ID: 1322774042.23181.11.camel@vanquo.pezone.net (view raw or flat)
Thread:
Lists: pgsql-hackers
On tor, 2011-12-01 at 14:37 +0100, Yeb Havinga wrote:
> On 2011-11-29 18:47, Peter Eisentraut wrote:
> > On tis, 2011-11-29 at 07:07 +0200, Peter Eisentraut wrote:
> >> On mån, 2011-11-28 at 11:41 +0100, Yeb Havinga wrote:
> >>> On 2011-11-15 21:50, Peter Eisentraut wrote:
> >>>> Patch attached.
> >>> I cannot get the patch to apply, this is the output of patch -p1
> >>> --dry-run on HEAD.
> >> I need to remerge it against concurrent range type activity.
> > New patch attached.
> 
> I'm looking at your patch. One thing that puzzled me for a while was 
> that I could not restrict access to base types (either built-in or user 
> defined). Is this intentional?

Works for me:

=# create user foo;
=# revoke usage on type int8 from public;
=# \c - foo
=> create table test1 (a int4, b int8);
ERROR:  permission denied for type bigint



In response to

Responses

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2011-12-01 21:19:04
Subject: Re: patch for type privileges
Previous:From: Jim ButtafuocoDate: 2011-12-01 21:11:29
Subject: Re: Postgresql 9.1 replication failing

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