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?
|
Список | 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 по дате отправления: