Re: Reset ACL to default for pg 8.0

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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com