Re: security via views

From: Peter Dockweiler <pdo(at)wikon(dot)de>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: security via views
Date: 2005-04-27 16:01:46
Message-ID: 200504271801.47297.pdo@wikon.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

yes this works. Just drop the rights on the table and grand the rights on the
view.

Peter

Am Mittwoch, 27. April 2005 17:52 schrieb Enrico Weigelt:
> Hi folks,
>
> we've got a larger project with several subsystems, which should
> run in their own security context / users.
>
> Most of the database access works over views and functions.
> For functions its possible to run them with separate privileges
> than the calling user. But is this also possible with views ?
> I've noticed that for views also GRANT is necessary (AFAIK a
> view is nothing else than a table with appropriate RULEs).
> Does it work to grant some user access to his own view, but
> not to the tables where the view works on ?
>
>
> thx

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vaneet Sharma 2005-04-27 16:43:42 Client Authentication problem
Previous Message pgsql-admin 2005-04-27 15:53:07 PostgreSQL 8.0.x on Windows XPe