about permissions
От | Remigiusz Sokolowski |
---|---|
Тема | about permissions |
Дата | |
Msg-id | Pine.GS4.4.02A.9905261403490.22097-100000@netra.gdansk.sprint.pl обсуждение исходный текст |
Ответы |
Re: [SQL] about permissions
|
Список | pgsql-sql |
hi! First short explanation: I create application in php. In scripts I need sometimes check if user has permissions to for example update values in some table So question: How should looks my queryi like? I mean something like select pg_class.relacl where relname='cust' and pg_class.relacl[2]='my_user=arwR'; (this query doesn't work) and another difficult problem: I don't know what place in relacl array is occupied by permissions for my user and of course can't check for string 'myuser=arwR' cause permissions could be 'arw', 'ar', 'r'. Naturally I can solve this by taking whole array and processing data in php, but I could be really fine to solve this inside postgresTIARem -------------------------------------------------------------------*------------ Remigiusz Sokolowski e-mail: rems@gdansk.sprint.pl * * -----------------------------------------------------------------*****----------
В списке pgsql-sql по дате отправления: