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

Started by Andreas Pflugover 22 years ago2 messages
#1Andreas Pflug
Andreas.Pflug@web.de

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

#2Rod Taylor
rbt@rbt.ca
In reply to: Andreas Pflug (#1)
Re: 7.4 acl: what is a*r*w*d*?

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