Just a question.
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 ?
Thanks in advance.
Luis Sousa
smime.p7s
Description: S/MIME Cryptographic Signature