mssqltips logo

SQL Server Security for Developers

(this is an on-demand video)

Sponsored by - IDERA

Webcast Abstract

The goal of this presentation is to teach you what you need to know as a developer about security within SQL Server. We'll look at using groups rather than individual logins for authentication and why it's useful to assign permissions to roles instead of users. From there we'll dive into permissions at the object level, starting with how to grant access to a table, allow execution of a stored procedure, and using a view to further restrict access when needed. This leads into the conversation about using all stored procedures, all dynamic SQL, or a hybrid (the most common) - the part most likely to generate heated discussion at the office! All of this in the context of building a security model that is easy for developers to work with, acceptable to DBA's, and satisfactory to the auditors. Getting good security in place does take some effort, but once it's there it's easy to maintain.

Speaker - Andy Warren

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.




More SQL Server Solutions












download





get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools