Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mJFLr-0004RF-5y for pgsql-admin@arkaria.postgresql.org; Thu, 26 Aug 2021 13:23:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mJFLq-0007f8-6R for pgsql-admin@arkaria.postgresql.org; Thu, 26 Aug 2021 13:23:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mJFLp-0007ez-Pv for pgsql-admin@lists.postgresql.org; Thu, 26 Aug 2021 13:23:25 +0000 Received: from mail-wr1-x42a.google.com ([2a00:1450:4864:20::42a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mJFLl-0007s3-9o for pgsql-admin@lists.postgresql.org; Thu, 26 Aug 2021 13:23:25 +0000 Received: by mail-wr1-x42a.google.com with SMTP id h4so5047572wro.7 for ; Thu, 26 Aug 2021 06:23:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=2FfjeiC7nc9zsarWlRieYWxQ9sSTH45NQxe8lUGBJSM=; b=jp2Wx5wo89xC9oh2AR4aCF8sx/bifwO8LtmxbIiONp/q6Yhwi5ZeX1pxVoVbLdMZKf S8a5FcDfyBZksqbw7TGA6FK8L6GQkLkrLOWApl6jTzWy33fmPsZuyIs1WCzWtFAA4kS8 w+0LZaidjFLKYVJm4/Bac6ZYoQ7+5fZaK/ZJ88Tmp8dD3gjlNs8FKUQYlLl1COfO7UBv c43+Rshtz12vSInqWy2ykZE6nztly3czyfSQo9FQ6/bVW8fvEK7ChVexIlr7Gl9lLat2 cdPJVss7zASAu0AfT1l3uTrDgnqUND+YUAaf7PUcybC4DIAF7R+FN1bVLJRQ4gtCywQo 4J1A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=2FfjeiC7nc9zsarWlRieYWxQ9sSTH45NQxe8lUGBJSM=; b=WAng618c5dluFJi39Na7J41vzzN8gUfSzVB+B31dffiDMBroqGhSQfhF4KxJsQVMSC KSHuRHvJwE0aXZRk8ekLBR8YUQkDsVceDCEMx6qWiEI/gZpuLXsgmdJiQl1+d232qIOH iukV7TSXARwSqXzDWD2cBeyDl2R6L9/8czzZgb98RQXdrV4/ByuGOdnjGTyWmjt/bOcN xhplvkrqmpJd8qOnrvvRrSk7X6wh4o9q9hjxMg+yQdVOad2Y0bqUgCn0Y7Cs+r7sOuX4 uOe/Z2Hp1ZAGxooJc8h9CFVnO0dxJCBPCYBFHerSu/GcXdE7u4NqOE6hOwU79RQMireZ uTXA== X-Gm-Message-State: AOAM531i6Cp48o496JjSuSUza6lz/1nX3/sY3P0Mg+ddg0LGFU6RGBWQ YBrr3nqCIPKmWi3XVb1C2kPyeg== X-Google-Smtp-Source: ABdhPJwrnsy7R7NLeUQ9Z+vWxXdl6YJ0LZmyk/stC0s4wYLqsag/1MZ1sAiTYaT1uqzHIyvS1Y0R4g== X-Received: by 2002:adf:c391:: with SMTP id p17mr4084907wrf.145.1629984196887; Thu, 26 Aug 2021 06:23:16 -0700 (PDT) Received: from localhost.localdomain ([88.116.133.170]) by smtp.gmail.com with ESMTPSA id m7sm8057181wmq.29.2021.08.26.06.23.16 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 26 Aug 2021 06:23:16 -0700 (PDT) Message-ID: Subject: Re: Restrict user's query row number From: Laurenz Albe To: "Burhan Akbulut (ETIYA)" , "pgsql-admin@lists.postgresql.org" Date: Thu, 26 Aug 2021 15:23:15 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.40.4 (3.40.4-1.fc34) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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