"Randi Joy" <rjoy(at)randijoy(dot)com> writes:
> I have a postgres v. 8.1 database on Windows XP and ODBC driver
> 8.01.02.00. I have created roles with permissions to a few views. When
> I use Psql command line client, Postgres does impose the security
> restrictions so that the roles only see the views they are configured
> to access.
Really? You haven't tried very hard, if by "see" you mean "can find out
information about" and not specifically "select from".
regards, tom lane