Postgres Pro
Downloads
Home   >   mailing lists

Re: create role/user management - Mailing list pgsql-sql

From Steve Midgley
Subject Re: create role/user management
Date
Msg-id CAJexoSKNMuRHD2ssKMFaYsa8inLKnDpZpD9zcYTBvZD5QX7KJA@mail.gmail.com
Whole thread Raw
In response to create role/user management  (Kirti Adesara <kdadesara@hotmail.com>)
List pgsql-sql
Tree view
On Sat, May 4, 2019 at 9:38 AM Kirti Adesara <kdadesara@hotmail.com> wrote:
Hi

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.

Can you clarify your intention/goal? You write that you want a user role to "select on specific tables" but "cannot access... specific tables." Do you mean you want by default a user role that can't access any functions, triggers or tables, and then can be "whitelisted" into access to a limited, defined list of tables?

Steve

pgsql-sql by date:

Previous
From: "Sonnenberg-Carstens, Stefan"
Date:
Subject: AW: plpython transforms vs. arrays
Next
From: "David G. Johnston"
Date:
Subject: Re: create role/user management