Josh Berkus wrote:
Luis,That's what I already made. The problem is when I do the update, I permission denied in all the tables for update and insert. The user that's making this operation only have select privilege.
Just a question.I just checked this. It works fine in 7.2.3.
I'm writing some rules to insert/update some data in my database, and I gave all the privileges on that view to the user, and only select on the tables.
When that user inserts data using the view, I thought that was user postgres that will do the rest ! But I got permission denied on those tables.
The idea was to create a layer, with the views, giving to that user permission on views to insert and update, and not to tables.
Is this possible ?
I think that you are missing a step. If you want to have an updatable view, then you need to define a Rule for updating it, such as:
kitchen=# create rule update_password as on update to user_password
kitchen-# do instead update "user" set "password" = NEW."password"
kitchen-# where user_id = OLD.user_id;
See the online docs, under Server Programming, for how to use the RULES system.
Any way, I'm using version 7.2.1-2 for debian.
Luis Sousa
smime.p7s
Description: S/MIME Cryptographic Signature
