SQL Saturday Parma 566 – Erland Sommarskog: Giving Permissions through Stored Procedures

SQL Saturday Parma 566 – Erland Sommarskog: Giving Permissions through Stored Procedures

Ciao a tutti,

Cominciamo questa penultima settimana precedente all’evento con la sessione del primo speaker straniero di questa edizione, Erland Sommarskog, intitolata “Giving Permissions through Stored Procedures. Vediamo quindi il suo abstract:

 

You probably know that with a stored procedure you can permit users to access or update data even if they have no direct permissions on the table. But you may have noticed that this does not work when the SP uses dynamic SQL.

In this session you will learn why it is so and techniques how you can use to overcome this. You will also learn that the same techniques can be to permit users to perform specific actions they need to do without granting them general high-level permissions on database or server level by packaging these actions into a stored procedure. You will also learn why should should be careful with setting a database TRUSTWORTHY.

The session should be of interest both to DBAs and application developers that need to consider advanced permissions in their stored procedures.

Per chi volesse partecipare, ricordiamo come sempre che le registrazioni sono ancora aperte al seguente indirizzo. Se non volete perdervi nessuna novità relativa all’evento invece, è possibile seguirci sui seguenti social:

A domani con la prossima sessione!

Leave a Reply

%d bloggers like this: