https://forum.aspitalia.com/forum/topic.aspx?PostID=429196Generated by feed.ASPItalia.com 'Cortana' 2022.8.29it-itTue, 04 Oct 2022 06:48:25 GMThttps://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#429196Fri, 16 Sep 2022 15:28:42 GMTCiao, <br/>ho bisogno di un aiuto per quanto vado a scrivere: <br/> <br/>ho una sp che all&#39;interno ha diversi update. Mi hanno chiesto di assegnare le grant di execute alla sp ma senza dare le grant di update sulle singole tabelle. <br/>So che &#232; possibile ma non riesco a trovare nulla sui vari gforum. <br/>Mi potete aiutare? <br/>Grazie in anticipo <br/> <br/>Giorgio<p>Continua a leggere <a href="https://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#429196"><em>Grant execute con update</em></a>.</p><hr /><p><a href="https://www.aspitalia.com/">(C) 2026 ASPItalia.com Network - All rights reserved</a></p>eusebio1006https://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#4291964https://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#429196#feedbackhttps://forum.aspitalia.com/forum/ws/commentRSS.aspx?url=http%3a%2f%2fforum.aspitalia.com%2fforum%2fpost%2f429196%2fgrant-execute-update.aspx%23429196https://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#429207Thu, 22 Sep 2022 07:14:01 GMTciao Giorgio, <br/> <br/>... non ho mica capito :D <br/> <br/>se garantisci l&#39;execute sulla stored procedure, puoi tranquillamente (come dovrebbe) evitare il &quot;db_datawriter&quot; sulle base table... <br/>se la login-&gt;db_user ha solo i grant EXECUTE, puo&#39; essere piu&#39; che sufficiente... <br/> <br/>ma forse non ho capito cosa intendi :D <br/> <br/>salutoni romagnoli <br/>-- <br/>Andrea<p>Continua a leggere <a href="https://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#429207"><em>RE: Grant execute con update</em></a>.</p><hr /><p><a href="https://www.aspitalia.com/">(C) 2026 ASPItalia.com Network - All rights reserved</a></p>Andrea Montanarihttps://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#4292071https://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#429207#feedbackhttps://forum.aspitalia.com/forum/ws/commentRSS.aspx?url=http%3a%2f%2fforum.aspitalia.com%2fforum%2fpost%2f429196%2fgrant-execute-update.aspx%23429207https://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#429208Thu, 22 Sep 2022 09:44:30 GMTCiao Andrea, grazie per la risposta innanzitutto. Quanto scrivi &#232; corretto ma per ragioni che non ho capito dando solo l&#39;execute all&#39;utente esce grant update permission denied on table ecc... <br/>Con altri casi &#232; bastato dare le grant di execute. <br/>Pu&#242; essere che la sp &#232; su uno schema e la tabella su un altro? <br/>Grazie <br/> <br/>Giorgio<p>Continua a leggere <a href="https://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#429208"><em>RE: Grant execute con update</em></a>.</p><hr /><p><a href="https://www.aspitalia.com/">(C) 2026 ASPItalia.com Network - All rights reserved</a></p>eusebio1006https://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#4292081https://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#429208#feedbackhttps://forum.aspitalia.com/forum/ws/commentRSS.aspx?url=http%3a%2f%2fforum.aspitalia.com%2fforum%2fpost%2f429196%2fgrant-execute-update.aspx%23429208https://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#429213Sat, 24 Sep 2022 15:58:39 GMTsalve Giorgio, <br/>si, gli schema diversi possono essere una problematica... <br/> <br/>provo a darci uocchiata anche io :D <br/> <br/>salutoni romagnoli <br/>-- <br/>Andrea<p>Continua a leggere <a href="https://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#429213"><em>RE: Grant execute con update</em></a>.</p><hr /><p><a href="https://www.aspitalia.com/">(C) 2026 ASPItalia.com Network - All rights reserved</a></p>Andrea Montanarihttps://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#4292131https://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#429213#feedbackhttps://forum.aspitalia.com/forum/ws/commentRSS.aspx?url=http%3a%2f%2fforum.aspitalia.com%2fforum%2fpost%2f429196%2fgrant-execute-update.aspx%23429213https://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#429236Tue, 04 Oct 2022 06:48:25 GMTLeggo solo ora la risposta. <br/>Purtroppo non ho trovato la soluzione e dato che queste grant servono all&#39;utente ho assegnato gli update sulle tabelle interessate alla sp....soluzione tampone che per&#242; fa persistere il problema. <br/>Non riesco a trovare nulla di soddisfacente per la risoluzione del problema. <br/>Spero tu sia pi&#249; fortunato di me :-) <br/>Graize <br/> <br/>Giorgio<p>Continua a leggere <a href="https://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#429236"><em>RE: Grant execute con update</em></a>.</p><hr /><p><a href="https://www.aspitalia.com/">(C) 2026 ASPItalia.com Network - All rights reserved</a></p>eusebio1006https://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#4292360https://forum.aspitalia.com/forum/post/429196/Grant-Execute-Update.aspx#429236#feedbackhttps://forum.aspitalia.com/forum/ws/commentRSS.aspx?url=http%3a%2f%2fforum.aspitalia.com%2fforum%2fpost%2f429196%2fgrant-execute-update.aspx%23429236