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

Re: Reset ACL to default for pg 8.0

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: "Juan C(dot) Aragon" <juan(at)keisercomputers(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Reset ACL to default for pg 8.0
Date: 2010-04-15 02:13:16
Message-ID: 201004150213.o3F2DGY03774@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Juan C. Aragon wrote:
> Hi Guys:
> 
>  
> 
> I need to know how to reset the ACL to default (null) for a function. This
> is for PostgreSQL 8.0.14 and 8.4.1 on Windows.
> 
> I used the User Interface to removed all the Privileges, but the ACL is
> still = {} 
> 
> I need to make the ACL to be blank (null), nothing in there.
> 
>  
> 
> Because if the ACL = {} and I do a db restore, it sets the ACL = <owner>,
> but I need it to be blank.

Well, if I create a table and look at pg_dump,  I see:

	ALTER TABLE public.test OWNER TO postgres;

and the owner has permissions by default on the table.  Perhaps you want
to revoke owner permissions on the table.

Where are you seeing this ACL?

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

In response to

Responses

pgsql-bugs by date

Next:From: Craig RingerDate: 2010-04-15 02:22:27
Subject: Re: Bug in CREATE FUNCTION with character type (CONFIRMED BUG)
Previous:From: Tom LaneDate: 2010-04-15 02:03:32
Subject: Re: initdb stores default client_encoding from environment-variable

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