Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: create role/user management
Date
Msg-id CAKFQuwYVVHSRYv3BS8FfC==qYJRBZi1yU_JJ-XFW96Oqdspy7A@mail.gmail.com
Whole thread Raw
In response to create role/user management  (Kirti Adesara <kdadesara@hotmail.com>)
Responses Re: create role/user management  (Rob Sargent <robjsargent@gmail.com>)
Re: create role/user management  (Steve Midgley <science@misuse.org>)
List pgsql-sql
Tree view
On Sat, May 4, 2019 at 9:38 AM Kirti Adesara <kdadesara@hotmail.com> wrote:
I have a database with multiple tables, functions and triggers in public schema.

You should stop using the 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.

Maybe provide an example what what is not presently working the way you expect and describe how you would like it to work - after refraining from using the public schema.

David J.

pgsql-sql by date:

Previous
From: Steve Midgley
Date:
Subject: Re: create role/user management
Next
From: Rob Sargent
Date:
Subject: Re: create role/user management