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 1mJGMB-0006OP-C5 for pgsql-admin@arkaria.postgresql.org; Thu, 26 Aug 2021 14:27:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mJGMA-0008Dd-6A for pgsql-admin@arkaria.postgresql.org; Thu, 26 Aug 2021 14:27:50 +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 1mJGM9-0008DU-Ry for pgsql-admin@lists.postgresql.org; Thu, 26 Aug 2021 14:27:49 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mJGM7-0008RL-6U for pgsql-admin@lists.postgresql.org; Thu, 26 Aug 2021 14:27:49 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 8F0B43801CB; Thu, 26 Aug 2021 16:27:45 +0200 (CEST) Received: from rs.plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ANPjHfP2VNbW; Thu, 26 Aug 2021 16:27:45 +0200 (CEST) Received: from [127.0.0.1] (dyndsl-091-248-071-250.ewe-ip-backbone.de [91.248.71.250]) by rs.plausibolo.de (Postfix) with ESMTPSA id 28B35380174; Thu, 26 Aug 2021 16:27:45 +0200 (CEST) Date: Thu, 26 Aug 2021 16:27:42 +0200 From: Holger Jakobs To: pgsql-admin@lists.postgresql.org, "Burhan Akbulut (ETIYA)" , "pgsql-admin@lists.postgresql.org" Subject: Re: Restrict user's query row number User-Agent: K-9 Mail for Android In-Reply-To: References: Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=----DA9T56MCBAB6TID6YANMJZU6VNN1FT Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------DA9T56MCBAB6TID6YANMJZU6VNN1FT Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Am 26=2E August 2021 14:05:34 MESZ schrieb "Burhan Akbulut (ETIYA)" : >Hello, > >Some tables that contain sensitive data can be accessed by many people fr= om the operation team=2E I want to limit rows the results of queries contai= ning these tables through client applications such as Pgadmin or DBeaver=2E > >Can I do this exactly? How can I do it if I can? > >PS: The operations team does not use similar queries=2E I can solve this = problem with using view or etc, if they are using the same queries=2E Howev= er, they produce new types of queries by combining different tables and tab= les containing sensitive data=2E > >Thanks for your help=2E > >Burhan Akbulut >Etiya > >[https://www=2Eetiya=2Ecom/images/e-newsletter/signature/etiya_logo=2Epng= ] >[http://www=2Eetiya=2Ecom/images/e-newsletter/signature/e_adres=2Epng] >[http://www=2Eetiya=2Ecom/images/e-newsletter/signature/facebook_icon=2Ep= ng] [http://www=2Eetiy= a=2Ecom/images/e-newsletter/signature/linkedin_icon=2Epng] = [http://www=2Eetiya=2Ecom/images/e-newsletter/signature/instagram_icon=2E= png] [http://www=2Eetiya=2Ecom/ima= ges/e-newsletter/signature/youtube_icon=2Epng] [http://www=2Eetiya=2Ecom/images/e-news= letter/signature/twitter_icon=2Epng] >[http://www=2Eetiya=2Ecom/images/e-newsletter/signature/0=2Epng] > >Burhan Akbulut >Senior Specialist, Database Management > > >M:+90 552 997 52 97 >E:burhan=2Eakbulut@etiya=2Ecom > > > > > >Yasal Uyari : >Bu elektronik posta asagidaki adreste bulunan Kosul ve Sartlara tabidir; >http://www=2Eetiya=2Ecom/gizlilik > >?IKTI ALMADAN ?NCE ?EVREYE OLAN SORUMLULUGUMUZU BIR KEZ DAHA D?S?NELIM=2E >PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING ANY DOCUMENT=2E Do you want to limit according to some criterion or the number of rows whi= ch may be returned? The first would be row level security=2E The second would be a view with a 'limit' clause=2E --=20 Holger Jakobs, Bergisch Gladbach +49 178 9759012 - sent from mobile, therefore short - ------DA9T56MCBAB6TID6YANMJZU6VNN1FT Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

Am 26=2E August 2021 14:05:= 34 MESZ schrieb "Burhan Akbulut (ETIYA)" <burhan=2Eakbulut@etiya=2Ecom&g= t;:

Hello,

 

Some tables that contain sensitive data can be acce= ssed by many people from the operation team=2E I want to limit rows the res= ults of queries containing these tables through client applications such as= Pgadmin or DBeaver=2E

 

Can I do this exactly? How can I do it if I can?
PS: The operations team does not use similar queries=2E I can solve this p= roblem with using view or etc, if they are using the same queries=2E Howeve= r, they produce new types of queries by combining different tables and tabl= es containing sensitive data=2E

Thanks for your help=2E

 

Burhan Akbulut

Etiya

 

<= img src=3D"http://www=2Eetiya=2Ecom/images/e-newsletter/signature/youtube_i= con=2Epng" width=3D"28" height=3D"42">
 
 
Burhan Akb= ulut
Senior Specialist, Database= Management
 
 
M:+90 552 997 52 97
E:burhan=2Eakbulut@etiya=2Ecom
 
 

 

Yasal Uyari : 
Bu elektronik posta asagidaki adreste bulunan Kosul ve Sartlara tabidir;

http://www=2Eetiya=2Ecom/gizlilik

=C3=87IKTI ALMADAN =C3=96NCE =C3=87EVREYE OLAN SORUMLULUGUMUZU BIR K= EZ DAHA D=C3=9CS=C3=9CNELIM=2E 
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING ANY DOCUMENT=2E=


Do you want to= limit according to some criterion or the number of rows which may be retur= ned?

The first would be row level security=2E

The second woul= d be a view with a 'limit' clause=2E


--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent f= rom mobile, therefore short -
------DA9T56MCBAB6TID6YANMJZU6VNN1FT--