Forum Discussion
Solved
Reader only access unable to login synapse workspace or SSMS into the database
Hello,
Just wondering
My colleagues were placed under the default role provided by Microsoft as a 'reader' under the synapse workspace.
But we do not understand why they are unable to signin the workspace or SSMS of synapse.
Would you be able to rectify it for us please?
This may be a good place to start (notably steps 6 - 10)
Also make sure they have the correct permissions to the right directories within the data lake if they need to query external tables or views using serverless or lake dbs.
This may be a good place to start (notably steps 6 - 10)
Also make sure they have the correct permissions to the right directories within the data lake if they need to query external tables or views using serverless or lake dbs.
Hellolcolbert,
Thank you for getting back to me,
I literally put the assignment group of my colleagues to connect the data base under the attached. However, she is still unable to access as a reader only.
Here is the comment that she is unable to access the datawarehouse under the attached. what would make the credential did not work?
Many thanks again
Nick
- So you have a security group created and you've added the group as a user in your database with a role like db_datareader. You've assigned users to that group, and when they try to log in using AAD in SSMS they still can't connect?
