| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Kirti Adesara <kdadesara(at)hotmail(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: role/user management |
| Date: | 2019-05-04 17:56:51 |
| Message-ID: | 868fbb69-cf40-d946-df38-d25de9d0b472@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On 5/4/19 12:44 PM, Kirti Adesara wrote:
> I have a database with multiple tables, functions and triggers in public
> schema.
>
> I want to create a user that can login to database and select on
> specific tables and cannot access to any functions, triggers and
> specific tables.
You haven't asked any questions -- please read the fine manual and them
come back with specific questions and you will be much more likely to
get help.
As a starting point, see:
https://www.postgresql.org/docs/11/sql-grant.html
-and-
https://wiki.postgresql.org/wiki/Guide_to_reporting_problems
HTH,
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2019-05-04 18:12:13 | Re: Issues with privileges carrying over after alter table owner |
| Previous Message | Kirti Adesara | 2019-05-04 16:44:34 | role/user management |