Forum Discussion
Sql endpoint access and DB access roles HELP!
Hello Eye0nine ,
Using ALTER ROLE or GRANT in SQL Endpoint
Microsoft Fabric does not support ALTER ROLE in the SQL Endpoint. Unlike traditional SQL Server databases, role management in Fabric is handled through Microsoft Entra ID (formerly Azure AD) rather than SQL roles. However, you can use the GRANT statement to provide object-level permissions.
For 2nd question, no the default role is not configurable within Fabric SQL Endpoints. Permissions are controlled at the workspace level through Fabric roles:
- Admin, Member, Contributor, Viewer (Read-only access).
Also for the question you asked what is the Default Role:
- If a user does not have explicit permissions, their access is determined by their workspace role (e.g., Viewer role allows read-only access).
- Object-level access can be fine-tuned using GRANT for specific users.
To manage user permissions effectively, you may need to assign workspace-level roles in Microsoft Fabric and then use GRANT for additional fine-grained control.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
"Hi, based on the link you provided, I see the following:
My next question is, how can I use ALTER ROLE or GRANT in the SQL endpoint? Can I change the default role or grant SELECT on an object to the default role? Also, what exactly is the default role?"
Hello Eye0nine ,
Using ALTER ROLE or GRANT in SQL Endpoint
Microsoft Fabric does not support ALTER ROLE in the SQL Endpoint. Unlike traditional SQL Server databases, role management in Fabric is handled through Microsoft Entra ID (formerly Azure AD) rather than SQL roles. However, you can use the GRANT statement to provide object-level permissions.
For 2nd question, no the default role is not configurable within Fabric SQL Endpoints. Permissions are controlled at the workspace level through Fabric roles:
- Admin, Member, Contributor, Viewer (Read-only access).
Also for the question you asked what is the Default Role:
- If a user does not have explicit permissions, their access is determined by their workspace role (e.g., Viewer role allows read-only access).
- Object-level access can be fine-tuned using GRANT for specific users.
To manage user permissions effectively, you may need to assign workspace-level roles in Microsoft Fabric and then use GRANT for additional fine-grained control.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi Eye0nine ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hello Eye0nine ,
I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.
If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thankyou.
Hi Eye0nine ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.