Re: Restrict user's query row number - Mailing list pgsql-admin
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;ÇIKTI ALMADAN ÖNCE ÇEVREYE OLAN SORUMLULUGUMUZU BIR KEZ DAHA DÜSÜNELIM.
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING ANY DOCUMENT.
Do you want to limit according to some criterion or the number of rows which may be returned?
The first would be row level security.
The second would be a view with a 'limit' clause.
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -
pgsql-admin by date: