Granting privileges on views to group roles

From: Marc Balmer <marc(at)msys(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: Granting privileges on views to group roles
Date: 2007-05-17 09:48:35
Message-ID: 20070517094835.GB6253@mail.msys.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am having a hard time here with PostgreSQL 8.2.4... What I want to do
is rather simple:

I have two login roles, user_A and admin_A, and a group role, group_A.
user_A is member of group_A

I create a table t_data, owned by admin_A
I create a view v_data, owned by admin_A
Now I grant SELECT privilege on view v_data to group_A

I would by now assume that user_A can SELECT data on v_data, but he can
not.

What am I doing wrong here? According to the docs, I should be able to
GRANT on views to group roles.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Wilson 2007-05-17 10:15:32 Re: Windows Vista Support
Previous Message Shane Ambler 2007-05-17 09:31:33 Re: basic postgres questions...