Tag

Read-Only User

1 views collected around this technical thread.

Laravel Tech Community
Laravel Tech Community
Oct 28, 2021 · Databases

Creating a Read‑Only User in SQL Server and Granting Stored Procedure Access

This guide explains how to create a read‑only login in Microsoft SQL Server, map it to specific databases, assign the db_datareader role, and optionally grant permission to view stored procedures, while also summarizing common server and database roles.

Database PermissionsRead-Only UserSQL Server
0 likes · 6 min read
Creating a Read‑Only User in SQL Server and Granting Stored Procedure Access