Re: Restrict user's query row number

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: "Burhan Akbulut (ETIYA)" <burhan(dot)akbulut(at)etiya(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Restrict user's query row number
Date: 2021-08-26 13:23:15
Message-ID: b61c3ad871e0472aff3579f2e2c3b72e63680c0e.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, 2021-08-26 at 12:05 +0000, Burhan Akbulut (ETIYA) wrote:
> I want to limit rows the results of queries containing these tables through client applications such as Pgadmin or DBeaver.

There is no way to do that.

Perhaps don't give them access to the tables, but only to a view with a LIMIT clause.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Holger Jakobs 2021-08-26 14:27:42 Re: Restrict user's query row number
Previous Message Bruce Momjian 2021-08-26 13:18:37 Re: Restrict user's query row number