Re: create role/user management

From: Steve Midgley <science(at)misuse(dot)org>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Kirti Adesara <kdadesara(at)hotmail(dot)com>, "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:51:50
Message-ID: CAJexoS+yYUHLSkuu6Ei+RXRX-JaWJdrdFB64Ztf_dF8-KF=YhQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, May 6, 2019 at 12:44 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> 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.
>

Thanks as always David for your contributions here. My question is mildly
off-topic, but our engineering team was recently discussing this great wiki
page (https://wiki.postgresql.org/wiki/Don%27t_Do_This)

Can you explain why this user should stop using public schema? Is that a
general principle or related to this user's situation? (If general, should
we add it to the "Don't Do This" page?)

Steve

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2019-05-06 20:08:19 Re: create role/user management
Previous Message Rob Sargent 2019-05-06 19:49:15 Re: create role/user management