about permissions - Mailing list pgsql-sql

From Remigiusz Sokolowski
Subject about permissions
Date
Msg-id Pine.GS4.4.02A.9905261403490.22097-100000@netra.gdansk.sprint.pl
Whole thread Raw
Responses Re: [SQL] about permissions
List 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 by date:

Previous
From: JT Kirkpatrick
Date:
Subject: RE: [SQL] using like
Next
From: "Emils Klotins"
Date:
Subject: CASE WHEN / 6.4.2? + no doc in installed documentation