How to create reader / read-only user in azure database.
Source code viewer
-- Run this on master database. CREATE LOGIN reader WITH password='MY_STRONG_PASSWORD'; -- Run this in your database. CREATE USER reader FOR login reader; ALTER USER reader WITH DEFAULT_SCHEMA = MY_SCHEMA; ALTER ROLE db_datareader ADD MEMBER reader; EXEC sp_addrolemember 'db_datareader', 'reader';Programming Language: SQL