Security

SQLServerCentral Article

SQL Server Security: Fixed Database Roles

  • Article

Brian is back with a new security article, this time working through the details of the fixed database roles. There are some important concepts here. In particular if you're not totally clear on the difference between dbo and db_owner, read this article.

(9)

You rated this post out of 5. Change rating

2019-09-18 (first published: )

64,305 reads

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.

(1)

You rated this post out of 5. Change rating

2003-10-10

10,627 reads

Blogs

From SQL Saturday to Day of Data

By

A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...

PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters

By

You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...

A New Word: La Guadière

By

la guadière – n. a glint of goodness you notice in something that you...

Read the latest Blogs

Forums

Refund tiket Garuda-Indonesia di Traveloka?

By abiaemma

Pengajuan Refund tiket (Garuda Indonesia) lebih muda melalui Whatsapp +62813÷85372÷153 [24Jam] atau (Call Center)...

non ascii columns in a utf-8 .txt file

By stan

hi, we couldnt get our upstream data source developers to supply what is sometimes...

PolyBase Trace Flags

By Leo.Miller

Are there any good articles on all the trace flags that are enabled on...

Visit the forum

Question of the Day

Running SQLCMD I

I run the SQLCMD utility as follows:

lcmd -S localhost -E
I then type this (the 1> is the prompt):
1> select @@version go
If I hit enter, what happens?

See possible answers