Whitepaper : Nuts and Bolts of Permissions and Security

Being in the computer industry is one of the most challenging things anyone can get into. When upgrading one’s knowledge to keep the data secure, there are many hurdles to cross. In this industry, where we look for quick, fast responses from development to deployment to sales, everyone is expected to deliver without compromising any of the business parameters. As we chase around the strict deadlines for delivery, the team tries to take shortcuts. That, for most cases, involves cutting corners and compromising on designing for secure systems. That is a concern for many organizations. Database administrators love to build a secure system to deploy applications delivered from the Application team.

This whitepaper gets back to the basics of security. It covers some of the fundamental building blocks that were added with SQL Server since the 2005 version that is worth noting till today in SQL Server 2019. It presents principals, logins and users, password policy troubleshooting, and the special user sysadmin.

Author: Pinal Dave

Pinal Dave is a SQL Server performance tuning expert and an independent consultant. He has authored twelve SQL Server database books, and 33 Pluralsight courses. Pinal has written over 5100 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with more than 17 years of hands-on experience, he holds a Master’s of Science degree and some database certifications.

Register to read the full whitepaper.

Topics : Database Security,

Products : SQL Secure,

Register for Free Whitepaper

Note: By filling and submitting this form you understand and agree that the use of IDERA’s website is subject to the General Website Terms of Use. Additional details regarding IDERA’s collection and use of your personal information, including information about access, retention, rectification, deletion, security, cross-border transfers and other topics, is available in the Privacy Policy.