Grant SELECT/Execute to View/Function but not underlying Table

From: Alex Magnum <magnum11200(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Grant SELECT/Execute to View/Function but not underlying Table
Date: 2015-09-24 11:28:16
Message-ID: CA+cR4zf4pDRuQfrRMj4KY8w9eADXbFW7vP+eCu_aMjgQQQJ8Mg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
is it possible to grant select to views and functions without the need to
also grant the user the SELECT privileges to the Tables used in the views
or functions?

That way I could create read only users on a website and limit their access
to the bare minimum.

Thanks in advance for any advise on this

Alex

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Maxim Boguk 2015-09-24 11:47:18 Re: Grant SELECT/Execute to View/Function but not underlying Table
Previous Message maxiangqian 2015-09-24 09:55:50 Use tar to online backup has an error