Postgres Pro
Downloads
Home   >   mailing lists

Thread: 7.4 acl: what is a*r*w*d*?

7.4 acl: what is a*r*w*d*?

From
Andreas Pflug
Date:
Starting with 7.4, I observe ACLs that look like  a*r*w*d*R*x*t*
This seems to be a 7.4 extension. Haven't found comments on this in the 
mailing list.

This will be interpreted by pgadmin2 and pgadmin3 as  GRANT SELECT, UPDATE, INSERT, DELETE, RULE, REFERENCE, TRIGGER
I wonder if this is correct.

Regards,

Andreas

Re: 7.4 acl: what is a*r*w*d*?

From
Rod Taylor
Date:
On Wed, 2003-04-23 at 04:30, Andreas Pflug wrote:
> Starting with 7.4, I observe ACLs that look like
>    a*r*w*d*R*x*t*
> This seems to be a 7.4 extension. Haven't found comments on this in the
> mailing list.
>
> This will be interpreted by pgadmin2 and pgadmin3 as
>    GRANT SELECT, UPDATE, INSERT, DELETE, RULE, REFERENCE, TRIGGER
> I wonder if this is correct.

Peter extended permissions to enable WITH GRANT OPTION.  The * indicates
you are allowed to grant the permission to others.

http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-grant.html

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc