From: | Alberto Cabello Sanchez <alberto(at)unex(dot)es> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Grants on rules |
Date: | 2004-07-06 07:23:28 |
Message-ID: | 20040706072328.GA3312@guadiana.unex.es |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
I am trying to mimic a table's behaviour on a view thru rules. More
precisely, I have a table (say, my_table(field1,field2)) and a view
(my_view as select my_field from my_table). For allowing inserts into
the view, I have create a rule on "insert into my_view" doing instead
insert into my_table(field1,field2) values (NEW.field1,NULL). It works
fine, but...
I can GRANT or REVOKE privileges (SELECT, INSERT and so on) on my_view
and my_table, but insert into my_view is always allowed, even for users
that haven't SELECT or INSERT privileges neither on my_table or my_view.
How can I restrict the users that can insert into my_view?
Thank you for your answers.
--
-----------------------
Alberto Cabello Sánchez
alberto(at)unex(dot)es
Servicio de Informática
924 289 351
-----------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Clodoaldo Pinto Neto | 2004-07-06 09:09:40 | Re: could not access file "$libdir/plpython" when restoring |
Previous Message | Antony Paul | 2004-07-06 04:22:55 | Windows GUI clients |