pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joseph Kennedy <joseph.kennedy.486@gmail.com>
To: Giovanni Biscontini <biscontini.g@es2000.it>
Cc: pgsql-general@postgresql.org
Subject: Re: PostgreSQL
Date: Tue, 7 Feb 2023 12:36:57 +0100
Message-ID: <81AB3CB7-93E6-4811-9097-5C535FA84BFC@gmail.com> (raw)
In-Reply-To: <CAOM+UfXknNh+9nTPbSWrvncxcBrU9tFRL4aLaBzgQdm6sJrPnw@mail.gmail.com>
References: <CAOM+UfXknNh+9nTPbSWrvncxcBrU9tFRL4aLaBzgQdm6sJrPnw@mail.gmail.com>


--Apple-Mail-E4E0FA72-EF30-4F11-B470-9A18A8159B05
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">RLS policy it only affects to command as SE=
LECT, INSERT, UPDATE, DELETE or can affects to operations on whole database,=
 table like vacuum or reindex etc ?<br><div dir=3D"ltr"><br><blockquote type=
=3D"cite">Wiadomo=C5=9B=C4=87 napisana przez Giovanni Biscontini &lt;biscont=
ini.g@es2000.it&gt; w&nbsp;dniu 07.02.2023, o&nbsp;godz. 12:16:<br><br></blo=
ckquote></div><blockquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF<div dir=3D=
"ltr">Hi Joseph,<div>&nbsp; &nbsp;one way to filter without RLS is using fun=
ctions to make queries:</div><div>this way you can cross check input paramet=
ers with login&nbsp;user (=3D user issuing query). Using functions&nbsp;slow=
 an execution but incapsulate query letting you be able even to parse input p=
arameters and filter results. Sorry but I have no time ref for RLS, and reme=
mber that before you can use RLS you must enable it on the table you want to=
 use in.</div><div>best regards, Giovanni</div></div><br><div class=3D"gmail=
_quote"><div dir=3D"ltr" class=3D"gmail_attr">Il giorno mar 7 feb 2023 alle o=
re 12:02 Joseph Kennedy &lt;<a href=3D"mailto:joseph.kennedy.486@gmail.com">=
joseph.kennedy.486@gmail.com</a>&gt; ha scritto:<br></div><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(20=
4,204,204);padding-left:1ex">I would like restrict access to sensitive or re=
stricted information for some users (eg. hide data of one or more clients fo=
r some database users).<br>
<br>
PostgreSQL allows to create security policy as Row-Level Security, policies b=
ased on the querying user.<br>
<br>
<br>
Are there any other alternatives to RLS, are there any better solutions??<br=
>
<br>
What are&nbsp; the advantages and disadvantages of RLS?<br>
<br>
How much RLS will cause a decrease in database performance?<br>
<br>
JK<br>
<br>
<br>
<br>
<br>
</blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr" c=
lass=3D"gmail_signature"><div dir=3D"ltr"><p class=3D"MsoNormal" style=3D"li=
ne-height:normal"><span style=3D"font-size:12pt">&nbsp;</span><span></span><=
/p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span style=3D"font-size:12pt">&nbsp;</span><span></span></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
b>Cordiali Saluti</b><span></span></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal">&=
nbsp;<span></span></p><p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt=
;line-height:normal"><img src=3D"https://ci3.googleusercontent.com/mail-sig/=
AIorK4wW12ZNDdF_BcmKN6zTAWE_BVey5jo0Vjx6DCd3Lh8QNf7OZ5pyIuCt8HHiwcR0LNmBay9N=
P-Y" data-unique-identifier=3D""><br></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span></span></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal">&=
nbsp;<span></span></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
b>&nbsp;</b><b><span style=3D"font-size:13pt;font-family:Arial,sans-serif">D=
ott. Giovanni Biscontini</span></b><span></span></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
b><span style=3D"font-size:12pt;font-family:Arial,sans-serif">&nbsp;[Divison=
e
Software]</span></b><span></span></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal">&=
nbsp;<span></span></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
b><span style=3D"font-size:13pt;color:black">&nbsp;</span></b><b><span style=
=3D"font-size:10pt;font-family:Arial,sans-serif">Str. Ponte Alto Sud, 74&nbs=
p;<br>
&nbsp;41123 Modena&nbsp; (MO)</span></b><span></span></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal">&=
nbsp;<span lang=3D"EN-GB" style=3D"font-size:10pt;font-family:Arial,sans-ser=
if">Phone:
059_452094 <br>
&nbsp;Fax: 059_8672171<br>
&nbsp;E-mail: </span><a href=3D"mailto:biscontini.g@es2000.it" target=3D"_bl=
ank">biscontini.g@es2000.it</a><span></span></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span lang=3D"EN-GB" style=3D"font-size:10pt;font-family:Arial,sans-serif">&n=
bsp;Skype: g.biscontini.eurosystem2000</span><span></span></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span style=3D"font-size:10pt;font-family:Arial,sans-serif">&nbsp;</span><spa=
n lang=3D"EN-GB" style=3D"font-size:10pt;font-family:Arial,sans-serif">WEB: <=
/span><a href=3D"http://www.es2000.it/"; title=3D"blocked::http://www.es2000.=
it/ http://www.es2000.it"; target=3D"_blank"><span lang=3D"EN-GB" style=3D"fo=
nt-size:10pt;font-family:Arial,sans-serif">https://www.es2000.it</span></a><=
span></span></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span lang=3D"EN-GB" style=3D"font-size:10pt;font-family:Arial,sans-serif">&n=
bsp;</span><span></span></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span style=3D"font-size:10pt;font-family:Arial,sans-serif">&nbsp;</span><spa=
n></span></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:12pt;line-height:normal"><span=
 style=3D"color:black">&nbsp;</span><span></span></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span style=3D"font-size:10pt">____________________________________</span><sp=
an></span></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span style=3D"font-size:10pt;font-family:Times,serif">Privacy e
riservatezza: il presente messaggio, cos=C3=AC come i relativi allegati, con=
tengono
dati ed informazioni da considerarsi strettamente riservate ed =C3=A8 indiri=
zzato
esclusivamente al destinatario sopra indicato, il quale =C3=A8 l'unico autor=
izzato a
trattarlo in osservanza delle norme del Regolamento UE 2016/679 (RGPD) .
Preghiamo chiunque ricevesse questo messaggio per errore di evitare di
copiarlo, divulgarlo, distribuirlo a terzi e di dare notizia al mittente
dell=E2=80=99errato invio, distruggendone poi l'eventuale copia cartacea e l=
a copia in
formato elettronico.</span><span></span></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span style=3D"font-size:10pt">Il titolare dei dati potr=C3=A0 esercitare tut=
ti i
diritti di cui all'art.7 del suddetto decreto tra cui quelli di accesso,
rettifica, aggiornamento, opposizione al trattamento e cancellazione</span><=
span></span></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
b><span lang=3D"EN-US" style=3D"font-size:8pt">Please, print this
e-mail only if necessary</span></b><span></span></p></div></div>
</div></blockquote></body></html>=

--Apple-Mail-E4E0FA72-EF30-4F11-B470-9A18A8159B05--





view thread (68+ messages)  latest in thread

Message-ID: <81AB3CB7-93E6-4811-9097-5C535FA84BFC@gmail.com>
Permalink:  ../81AB3CB7-93E6-4811-9097-5C535FA84BFC@gmail.com/
Also on:    postgresql.org/message-id/81AB3CB7-93E6-4811-9097-5C535FA84BFC@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: joseph.kennedy.486@gmail.com, biscontini.g@es2000.it
  Subject: Re: PostgreSQL
  In-Reply-To: <81AB3CB7-93E6-4811-9097-5C535FA84BFC@gmail.com>
  References: <CAOM+UfXknNh+9nTPbSWrvncxcBrU9tFRL4aLaBzgQdm6sJrPnw@mail.gmail.com> <81AB3CB7-93E6-4811-9097-5C535FA84BFC@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox