From: | Remigiusz Sokolowski <rems(at)gdansk(dot)sprint(dot)pl> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | about permissions |
Date: | 1999-05-26 12:23:38 |
Message-ID: | Pine.GS4.4.02A.9905261403490.22097-100000@netra.gdansk.sprint.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 postgres
TIA
Rem
-------------------------------------------------------------------*------------
Remigiusz Sokolowski e-mail: rems(at)gdansk(dot)sprint(dot)pl * *
-----------------------------------------------------------------*****----------
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1999-05-26 13:42:14 | Re: [SQL] about permissions |
Previous Message | Brett W. McCoy | 1999-05-25 23:45:51 | Re: [SQL] using like |