Postgres Pro
Downloads
Home   >   mailing lists

Restrict user's query row number - Mailing list pgsql-admin

From Burhan Akbulut (ETIYA)
Subject Restrict user's query row number
Date
Msg-id VI1PR01MB703983265286DE36A7FE7AB589C79@VI1PR01MB7039.eurprd01.prod.exchangelabs.com
Whole thread Raw
Responses Re: Restrict user's query row number  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: Restrict user's query row number  (Bruce Momjian <bruce@momjian.us>)
Re: Restrict user's query row number  (Holger Jakobs <holger@jakobs.com>)
List pgsql-admin
Tree view

Hello,

 

Some tables that contain sensitive data can be accessed by many people from the operation team. I want to limit rows the results of queries containing these tables through client applications such as Pgadmin or DBeaver.

 

Can I do this exactly? How can I do it if I can?

PS: The operations team does not use similar queries. I can solve this problem with using view or etc, if they are using the same queries. However, they produce new types of queries by combining different tables and tables containing sensitive data.

Thanks for your help.

 

Burhan Akbulut

Etiya

 

body { background-color: #fff; } table { border-spacing: 1px; border-collapse: collapse; } td img {} .details { font-family: Arial Narrow; font-size: 10px; font-weight: bold; color: #69737a; padding-bottom: 5px; } .share { text-align: right; } .share img { margin-left: 10px; }
 
 
Burhan Akbulut
Senior Specialist, Database Management
 
 
M:+90 552 997 52 97
E:burhan.akbulut@etiya.com
 
 

 

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

http://www.etiya.com/gizlilik

ÇIKTI ALMADAN ÖNCE ÇEVREYE OLAN SORUMLULUGUMUZU BIR KEZ DAHA DÜSÜNELIM. 
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING ANY DOCUMENT.

pgsql-admin by date:

Previous
From: Gokan Atmaca
Date:
Subject: Re: PgBackrest
Next
From: Bruce Momjian
Date:
Subject: Re: Restrict user's query row number