From: | "Juan C(dot) Aragon" <juan(at)keisercomputers(dot)com> |
---|---|
To: | "'Bruce Momjian'" <bruce(at)momjian(dot)us> |
Cc: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: Reset ACL to default for pg 8.0 |
Date: | 2010-04-15 14:09:47 |
Message-ID: | 000f01cadca5$4ea4d3e0$ebee7ba0$@com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Thanks Bruce for replying.
The ACL is display in the PgAdmin tool for Windows on the properties for a
table or function. ACL is the Privileges. By default, when you create a new
function or table, the ACL is null. However, if you add some privileges, and
then remove all, the ACL is not longer null, it displays the brackets {}.
I just need to know if the brackets are normal when all the privileges are
remove. Or how to reset the privileges (ACL) to default (null).
Thanks,
Juan C. Aragon
From: pgsql-bugs-owner(at)postgresql(dot)org
[mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of Bruce Momjian
Sent: Wednesday, April 14, 2010 10:13 PM
To: Juan C. Aragon
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Aditya Vats | 2010-04-15 14:14:36 | BUG #5424: Not able to Install |
Previous Message | Tom Lane | 2010-04-15 13:59:37 | Re: Bug in CREATE FUNCTION with character type (CONFIRMED BUG) |