<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><p style="margin-bottom: 0cm; line-height: 100%">Io uso i comandi
così da psql (server debian 8.2, postgres 9.4.5)
</p>
<p style="margin-bottom: 0cm; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0cm; line-height: 100%">Tabella:</p>
<p style="margin-bottom: 0cm; line-height: 100%">GRANT SELECT,
INSERT, UPDATE, DELETE ON schema.tabella TO gruppo;
</p>
<p style="margin-bottom: 0cm; line-height: 100%">GRANT USAGE, SELECT,
UPDATE ON schema.tabella_id_seq TO gruppo; (id sequenze contatori
indici, sennò ti lascia modificare e cancellare ma non inserire
nuove tuple)</p>
<p style="margin-bottom: 0cm; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0cm; line-height: 100%">Schema:</p>
<p style="margin-bottom: 0cm; line-height: 100%">GRANT SELECT,
INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA schema TO gruppo;</p>
<p style="margin-bottom: 0cm; line-height: 100%">GRANT USAGE, SELECT,
UPDATE ON ALL SEQUENCES IN SCHEMA schema TO gruppo;</p>
<p style="margin-bottom: 0cm; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0cm; line-height: 100%">Per il gruppo in
sola lettura solo SELECT</p>
<p style="margin-bottom: 0cm; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0cm; line-height: 100%">ciao</p><br><br><div><hr id="stopSpelling">From: pietro.rossin@arpa.fvg.it<br>To: gfoss@lists.gfoss.it<br>Date: Wed, 4 Nov 2015 13:54:39 +0000<br>Subject: [Gfoss] Postgresql e permessi - un po' di confusione..<br><br>
<style><!--
.ExternalClass p.ecxMsoNormal, .ExternalClass li.ecxMsoNormal, .ExternalClass div.ecxMsoNormal {
font-size:11.0pt;
font-family:"Calibri",sans-serif;
}
.ExternalClass a:link, .ExternalClass span.ecxMsoHyperlink {
color:#0563C1;
text-decoration:underline;
}
.ExternalClass span.ecxMsoHyperlinkFollowed {
color:#954F72;
text-decoration:underline;
}
.ExternalClass span.ecxStileMessaggioDiPostaElettronica17 {
font-family:"Calibri",sans-serif;
color:windowtext;
}
.ExternalClass .ecxMsoChpDefault {
font-family:"Calibri",sans-serif;
}
.ExternalClass div.ecxWordSection1 {
}
--></style>
<div class="ecxWordSection1">
<p class="ecxMsoNormal">Buon giorno</p>
<p class="ecxMsoNormal">Ho ancora un po’ di confusione sui grant di Postrgesql…</p>
<p class="ecxMsoNormal"><br></p></div></div> </div></body>
</html>