Re: ACL-related adt functions: aclcontains vs aclcheck - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ACL-related adt functions: aclcontains vs aclcheck
Date
Msg-id 6600.1005168365@sss.pgh.pa.us
Whole thread Raw
In response to ACL-related adt functions: aclcontains vs aclcheck  (fche@redhat.com (Frank Ch. Eigler))
List pgsql-hackers
fche@redhat.com (Frank Ch. Eigler) writes:
> Is there a good reason why the aclcontains() UDF in utils/adt/acl.c is
> defined as it is, instead of calling over to aclcheck() in
> catalog/aclchk.c?

Backwards compatibility?

> With that, aclcontains('{"group foo=r"}',"user bar=r")
> would return true if bar is in foo.

I suspect what you are really after is a function that tests "is
privilege x available to user y given this ACL?"  That would be a
good thing to have, but I'd say make a new function for it; don't
arbitrarily redefine old functions, no matter how useless you might
think they are as-is.
        regards, tom lane


pgsql-hackers by date:

Previous
From: fche@redhat.com (Frank Ch. Eigler)
Date:
Subject: ACL-related adt functions: aclcontains vs aclcheck
Next
From: "Jim Buttafuoco"
Date:
Subject: Re: Storage Location Patch Proposal for V7.3