From: | "Alessandro" <a(dot)zipoli(at)sdb(dot)it> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | About selecting rows |
Date: | 2002-04-08 13:57:58 |
Message-ID: | 00d601c1df05$64196160$5b7a760a@sdb.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I've a table "users" with columns id, login and sec_level, where the latter
contains an integer 1..3.
Each db user logs in with his username. Till today I left access to the
record (of another table "works") that had, in the column "requested_by",
the same name of the current db user, with
select id, id from works where requested_by = ".get_session("UserID")."
order by id desc
Now I'd like that users with sec_level 2 and 3 can access to all records in
works table. Can I do it with an unique instruction inserting Case.. when
controls? And how?.
Thanks a lot
A.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-04-08 14:09:54 | Re: inherited columns as foreign keys WAS "no subject" |
Previous Message | tony | 2002-04-08 13:42:35 | Re: I18n & Pgaccess ( & psql) |