Re: Postgres limitation in user management

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: "Kar, Swapnil (TR Technology)" <Swapnil(dot)Kar(at)thomsonreuters(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgres limitation in user management
Date: 2023-11-04 21:59:27
Message-ID: AF0F2632-FF13-4BF0-8397-2DE030BEE2CC@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Nov 2, 2023, at 23:26, Kar, Swapnil (TR Technology) <Swapnil(dot)Kar(at)thomsonreuters(dot)com> wrote:
> We want Support users to have no SELECT or DML privilege but only ALTER TABLE to perform any troubleshooting in the database.

If a user has no ability to do SELECT or DML, they won't be able to "troubleshoot" the database. They may be able to apply migrations, but if essentially any problem arises in the database, at least SELECT will be required.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-11-04 22:02:26 Re: Postgres limitation in user management
Previous Message Peter J. Holzer 2023-11-04 21:53:21 Re: Postgres limitation in user management