Postgres Pro
Downloads
Home   >   mailing lists

Reset ACL to default for pg 8.0 - Mailing list pgsql-bugs

From Juan C. Aragon
Subject Reset ACL to default for pg 8.0
Date
Msg-id 000001cada97$581fb3f0$085f1bd0$@com
Whole thread Raw
Responses Re: Reset ACL to default for pg 8.0  (Bruce Momjian <bruce@momjian.us>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: initdb stores default client_encoding from environment-variable
Next
From: "y.y.chen"
Date:
Subject: BUG #5414: pg_dump failure from database 8.4.3 to 8.4.3