From: | "Alex Bolenok" <abolen(at)chat(dot)ru> |
---|---|
To: | "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Parsing an ACLITEM entry |
Date: | 2000-07-10 07:52:40 |
Message-ID: | 005001bfea43$d58031c0$df02a8c0@artey.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello all,
I am developing a mutli-user system using Postgres. I don't want to manage
my own user/group/permission tables, so I am going to use Postgres ones. But
I cannot parse ACLITEM types it returns. They are not convertible at all,
and the only logical operator defined on this type always returns TRUE, when
I try to find out if the certain user has certain access type to the table,
i.e.:
ikar=# SELECT relacl, relacl ~ 'user Vasya=w' AS canupdate FROM pg_class
WHERE relname = 't_order';
relacl | canupdate
-----------------+-----------
{"=","Vasya=r"} | t
(1 row)
We see, that user Vasya has only read access to the table (can only SELECT).
But the query returns TRUE when we compare this ACLITEM[] with 'user Vasya =
w' (it means that Vasya can UPDATE / DELETE the table).
Is it a bug, or I am doing something wrong?
Thanks,
Alex Bolenok.
From | Date | Subject | |
---|---|---|---|
Next Message | Giles Lean | 2000-07-10 09:15:51 | Re: Slashdot discussion |
Previous Message | Przem Kowalczyk | 2000-07-10 07:51:28 | Counting affected rows |