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

Предыдущее
От: JT Kirkpatrick
Дата:
Сообщение: RE: [SQL] using like
Следующее
От: "Emils Klotins"
Дата:
Сообщение: CASE WHEN / 6.4.2? + no doc in installed documentation