Problem with function aclcontains, features or bug?

Поиск
Список
Период
Сортировка
От Vadim I. Passynkov
Тема Problem with function aclcontains, features or bug?
Дата
Msg-id 3A913A8F.93D4BEB2@axxent.ca
обсуждение исходный текст
Ответы Re: Problem with function aclcontains, features or bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Hi All,

I have some problem with get permission for table/view before make real
SELECT/UPDATE/INSERT/DELETE operations.

spidermon=# \d objects_view
          View "objects_view"
...

spidermon=# \z objects_view
   Access permissions for database "spidermon"
   Relation   |        Access permissions
--------------+----------------------------------
 objects_view | {"=","pvi=r","group netadmin=r"}
(1 row)

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

It's result OK.
But, next result is wrong.

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

Same problem with permission for group.

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

FreeBSD 4.2,  postgresql 7.0.3.

Thanks

--

 Vadim I. Passynkov, Axxent Corp.
 mailto:pvi@axxent.ca

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Reinhard Max
Дата:
Сообщение: Re: NOTICE: pg_setlocale()
Следующее
От: Emily Carl
Дата:
Сообщение: Re: Regresstion Tests do not find PGLIB directory