Bruce Momjian wrote:
Josh Berkus wrote:Offcourse, but when I'm giving permissions to insert and update on views, I have to give those permissions also to the tables !! (those operations that are executed on rules)
Luis,Views have always had their own permissions.
Just a question.This is a known problem.
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 know that permissions for Functions has been addressed in 7.3. However, I am not sure about permissions for updatable views. Tom, Bruce?
Luis Sousa
smime.p7s
Description: S/MIME Cryptographic Signature
