Skip site navigation (1) Skip section navigation (2)

Re: Problem with function aclcontains, features or bug?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pvi(at)axxent(dot)ca
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Problem with function aclcontains, features or bug?
Date: 2001-02-19 16:36:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
"Vadim I. Passynkov" <pvi(at)axxent(dot)ca> writes:
> But, next result is wrong.

> spidermon=# SELECT aclcontains ( ( SELECT relacl FROM pg_class where
> relname = 'objects_view' ), 'user pvi=w' );
>  aclcontains 
> -------------
>  t
> (1 row)

aclcontains() is defined in a bizarre and useless fashion in pre-7.1
releases --- IIRC, it returns T in this example if there is an entry
mentioning user pvi in the ACL list, regardless of whether it grants
w access or not.  This is changed for 7.1, but it still doesn't tell
you what you really want to know, which is whether pvi has w access
(possibly via a group) or not.

> How I can know permission for user/group before make real operations?

There's no good way at the moment.  Sorry.

			regards, tom lane

In response to


pgsql-bugs by date

Next:From: Peter EisentrautDate: 2001-02-19 17:10:21
Subject: Re: Regresstion Tests do not find PGLIB directory
Previous:From: pgsql-bugsDate: 2001-02-19 16:00:20
Subject: Not able to connect to PostgreSQL in Linux!

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group