Skip to main content
Database Administrators

Return to Question

Simplify to read
Source Link
edit approved Nov 3, 2018 at 15:24
El.Hum
edit approved Nov 3, 2018 at 15:24
El.Hum
  • 182
  • 8

I am trying to assign a SQL Server database role to a user who just needs to be able to see dataable to see data across all tables. I
I was wondering what is the difference between db_datareaderdb_datareader and db_denydatewriterdb_denydatawriter? From
From the documentation I don't seem to realize any difference.

Thanks,

I am trying to assign a SQL Server database role to a user who just needs to be able to see data across all tables. I was wondering what is the difference between db_datareader and db_denydatewriter? From the documentation I don't seem to realize any difference.

Thanks,

I am trying to assign a SQL Server database role to a user who just needs to be able to see data across all tables.
I was wondering what is the difference between db_datareader and db_denydatawriter?
From the documentation I don't seem to realize any difference.

Thanks,

Source Link
Nico M.
Nico M.
  • 77
  • 1
  • 3
  • 13

what is the difference between db_datareader and db_denydatawriter?

I am trying to assign a SQL Server database role to a user who just needs to be able to see data across all tables. I was wondering what is the difference between db_datareader and db_denydatewriter? From the documentation I don't seem to realize any difference.

Thanks,