SQLServerCentral Article

Fixed Database Roles

  • Article

This article covers four of the fixed database roles (db_datareader, db_datawriter, db_denydatareader, and db_denydatawriter). If you're new to SQL security (and maybe even if you're not) this article is worth reading.

5 (1)


10,172 reads


Storage Field Day 23 – HammerSpace


I am thrilled to have been a part of this year’s Storage Field Day...

Daily Coping 16 May 2022


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Saturday Jacksonville Slide Decks


Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous...

Read the latest Blogs


Row wise sum based on condition

By parthi

Hi All, I have an input like below. mytable: id | name | no...

Mái xếp Hùng Linh

By maixephunglinh

Mái xếp Hùng Linh là đơn vị chuyên thi công các loại mái hiên...

why execution plan high cost on clustered index scan and how to mimize cost of c

By ahmed_elbarbary.2010

I work on sql server 2019 i have clustered index scan 98 percent how...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers