Problem with GRANT

  Hello,

  I have a small database created by the user demo. This database has some
 views.

  View 'A' uses tables 'X', 'Y', and 'Z' filtered with a column=1;
  View 'B' uses same tables, but filtered with the same column=2;
  View 'C' uses views 'A' and 'B' to get everything.

  Now, with the user demo, all is ok. I recently created other user called
 'outro'. Connecting to the database, it didn't have any access at all. Ok,
 it should be like this. So, I used GRANT on all tables and views to give
 the 'outro' user access.

  I used: GRANT ALL ON A, B, C, X, Y, Z TO outro;

  Now, user 'outro' can select all tables, except the views!!! Why?!

  Example:

     I try to select * from C, it gives ERROR: B: permission denied.
     I tryed select * from B and it gives: ERROR: X: permission denied.
     However, if I select from table 'X' the user has access to it!

     Why is it giving theese permission errors if I've granted all to all
 tables/views?

  Any hints?

  Thanks,
  Raul

 --
 Raul Miguel Pinheiro de Carvalho
 ISR - Instituto de Sistemas e Robotica, Porto
 e-mail: rmpc@fe.up.pt