Re: role/user management

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

In response to

Browse pgsql-admin by date

  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