From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | sylsau14(at)hotmail(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Questions about privileges |
Date: | 2006-03-04 21:50:35 |
Message-ID: | 20060304215035.GH29180@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, Mar 04, 2006 at 05:08:27AM -0800, sylsau14(at)hotmail(dot)com wrote:
> I have got one table named books with several columns.
> * The first question is :
>
> - All users can find titles, codes and prices of books (which are
> columns of the table books)
>
> So, I would like if a solution existed for that (to allow all users to
> access only at the columns titles, codes and prices).
Create a view and only grant access to that.
The next two questions I can't help with
> * My last question is :
>
> - Mister X can update the column quantity of the table books where the
> column codes is equal to 2 but He can't access at others datas of the
> table books.
>
> But, I don't know how to limit the update of the column quantity only
> where column codes is equal to 2.
> Someone would have an idea to do that ?
Same thing. Create a view with what he can see and make it updatable
with some rules.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Nasby | 2006-03-05 00:25:46 | Re: Insert fails when it shouldn't |
Previous Message | Martijn van Oosterhout | 2006-03-04 21:47:48 | Re: What query on system tables retrieves table or queries definitoin |