Re: create role/user management

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Kirti Adesara <kdadesara(at)hotmail(dot)com>
Cc: "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: create role/user management
Date: 2019-05-06 19:43:40
Message-ID: CAKFQuwYVVHSRYv3BS8FfC==qYJRBZi1yU_JJ-XFW96Oqdspy7A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Sat, May 4, 2019 at 9:38 AM Kirti Adesara <kdadesara(at)hotmail(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rob Sargent 2019-05-06 19:49:15 Re: create role/user management
Previous Message Steve Midgley 2019-05-06 19:35:37 Re: create role/user management