| 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: | Whole Thread | Raw Message | 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 |