Stairway to SQL Server Security

Stairway to SQL Server Security Level 4: Permissions

A permission gives a principal access to an object to perform certain actions on or with the object. SQL Server has a mind-numbingly huge number of permissions that you can grant to a principal, and you can even deny or revoke those permissions. This sounds a bit complicated, but by the end of this stairway level you’ll understand how SQL Server permissions work and how you can exert very granular control over object creation, data access, and other types of actions on database and server objects.

External Article

Redgate Summit: The Database DevOps Transformation

Digital transformation and data modernization are frequently cited as high-value strategic projects that are crucial to achieving competitive advantage. At the same time, delivery of code in agile and predictable ways has led to many businesses adopting DevOps practices. Throughout this event we will explore how Database DevOps can be the function that accelerates transformation projects.

Join us On October 6th as we invite experts to share their insider tips and tricks.

Blogs

Why You Need Presentation Skills

By

And no, the answer is not because you want to be a Microsoft MVP....

Daily Coping 29 Sep 2022

By

Today’s coping tip is to avoid saying “I should” and make time to do...

How to Calculate Compound Rate in Power BI

By

Recently I had an interesting use case where I had to a compound calculation...

Read the latest Blogs

Forums

Insert data into multiple tables after each batch of 100000 rows

By PJ_SQL

Hello! I have a table with 2 million rows. I need to insert data...

Idempotent Column Drops

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Idempotent Column Drops

T-SQL Language Changes in SQL Server 2022 Part 2

By Frank Dolan

Comments posted to this topic are about the item T-SQL Language Changes in SQL...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers