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

Reset ACL to default for pg 8.0

From: "Juan C(dot) Aragon" <juan(at)keisercomputers(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Reset ACL to default for pg 8.0
Date: 2010-04-12 23:24:48
Message-ID: 000001cada97$581fb3f0$085f1bd0$@com (view raw or flat)
Thread:
Lists: pgsql-bugs
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.

 

Any help I will appreciate it.

 

Thanks,

 

Juan C. Aragon

Responses

pgsql-bugs by date

Next:From: y.y.chenDate: 2010-04-13 01:03:07
Subject: BUG #5414: pg_dump failure from database 8.4.3 to 8.4.3
Previous:From: Robert HaasDate: 2010-04-12 13:23:56
Subject: Re: initdb stores default client_encoding from environment-variable

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