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
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 |