Postgres Pro
Downloads
Home   >   mailing lists

Grant SELECT/Execute to View/Function but not underlying Table - Mailing list pgsql-general

From Alex Magnum
Subject Grant SELECT/Execute to View/Function but not underlying Table
Date
Msg-id CA+cR4zf4pDRuQfrRMj4KY8w9eADXbFW7vP+eCu_aMjgQQQJ8Mg@mail.gmail.com
Whole thread Raw
Responses Re: Grant SELECT/Execute to View/Function but not underlying Table
Re: Grant SELECT/Execute to View/Function but not underlying Table
Re: Grant SELECT/Execute to View/Function but not underlying Table
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: maxiangqian
Date:
Subject: Use tar to online backup has an error
Next
From: Maxim Boguk
Date:
Subject: Re: Grant SELECT/Execute to View/Function but not underlying Table