db_datareader

External Article

Blocking SQL Server db_datareader, db_datawriter, and db_owner Permissions

  • Article

n a database I currently support, the application makes use of db_datareader and db_datawriter to give permissions to the tables. In a different database, it's even worse as the application uses db_owner. We're adding new tables to both databases and we don't want the application to have access to these tables. How can I deal with the use of these three roles?

2013-04-02

3,632 reads

Blogs

Restore SQL Server Database to an OrbStack Container

By

In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...

Day of Data Baton Rouge Slides and Code

By

Thanks to everyone for attending my talk today at Day of data Baton Rouge...

Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server

By

Here’s the scenario: one of my SQL Server instances migrated to the DR array....

Read the latest Blogs

Forums

PowerBI Question - Data Sources

By Brandie Tarvin

I don't see a PowerBI forum, so I'm posting here. I have a need...

SQL Server Certificates

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Certificates

Connect an Azure Function to Azure SQL database Using a Managed Identity

By Kunal Rathi

Comments posted to this topic are about the item Connect an Azure Function to...

Visit the forum

Question of the Day

SQL Server Certificates

Which of these is not true for certificates used for SQL Server connections?

See possible answers