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.

Topics :

Products :

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.

Try SQL Secure FREE for 14 days

SQL Secure

View and manage SQL Server permissions

  • Identify existing vulnerabilities in your SQL Server environment
  • Harden security policies across SQL Servers
  • Rank security levels with the security report card
  • Analyze and report on user permissions across SQL Server objects
  • Comply with audits
    using customizable templates
    for PCI, HIPAA and more

Start for Free