Fw: [GENERAL] Views permessions

2011-05-20 Thread salah jubeh
- Forwarded Message - From: salah jubeh To: Tom Lane Cc: pgsql Sent: Friday, May 20, 2011 3:54 PM Subject: Re: [GENERAL] Views permessions I have found the table where views are roles- permissions are stored and I checked it automatically and still permissions are identical  i.e

Re: [GENERAL] Views permessions

2011-05-20 Thread salah jubeh
a bug or something like that... Regards   From: Tom Lane To: salah jubeh Cc: pgsql Sent: Friday, May 20, 2011 3:47 PM Subject: Re: [GENERAL] Views permessions salah jubeh writes: > There is a problem confusing me. I have two views 'VIEW1' and '

Re: [GENERAL] Views permessions

2011-05-20 Thread Tom Lane
salah jubeh writes: > There is a problem confusing me. I have two views 'VIEW1' and 'VIEW2' > 1. VIEW2 depends on VIEW1 > 2. VIEW2 and VIEW1 have the exact permissions > 3. I can execute SELECT * from VIEW1 ; without problem > 4. When I execute SELECT * from VIEW2; I get > ERROR: permissio

[GENERAL] Views permessions

2011-05-20 Thread salah jubeh
Hello Guys, There is a problem confusing me. I have two views 'VIEW1' and 'VIEW2'  1. VIEW2 depends on VIEW1 2. VIEW2 and VIEW1 have the exact permissions 3. I can execute  SELECT * from VIEW1 ; without problem 4. When I execute  SELECT * from VIEW2; I get  ERROR:  permission denied for rel