wiki:connect_azure_database
Differences
This shows you the differences between two versions of the page.
| wiki:connect_azure_database [2024/04/25 11:14] – created antisa | wiki:connect_azure_database [2024/05/06 12:45] (current) – [Read-only user] Move EXEC sp_addrolemember... cmd antisa | ||
|---|---|---|---|
| Line 19: | Line 19: | ||
| **4.** Switch to DB (e.g. somedb_DEV) to which you need access and create user | **4.** Switch to DB (e.g. somedb_DEV) to which you need access and create user | ||
| CREATE USER rouser FROM LOGIN my_readonlylogin; | CREATE USER rouser FROM LOGIN my_readonlylogin; | ||
| + | |||
| + | Add read permissions to user | ||
| + | EXEC sp_addrolemember ' | ||
| You need to repeat this step for each DB. | You need to repeat this step for each DB. | ||
| Line 25: | Line 28: | ||
| SELECT * FROM sys.sysusers; | SELECT * FROM sys.sysusers; | ||
| - | Add read permissions to user (needed only once) | ||
| - | EXEC sp_addrolemember ' | ||
| Now use my_readonlylogin as user to login not the user created :shrug: Under database field select the database as well otherwise the default is to connect to master DB. | Now use my_readonlylogin as user to login not the user created :shrug: Under database field select the database as well otherwise the default is to connect to master DB. | ||
wiki/connect_azure_database.1714043680.txt.gz · Last modified: by antisa