On Sat, Mar 04, 2006 at 05:08:27AM -0800, sylsau14@xxxxxxxxxxx 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@xxxxxxxxx> 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.
Attachment:
signature.asc
Description: Digital signature
