Share via

Is it possible to have guest user in Azure SQL?

Samir KHIMANI 21 Reputation points
2020-09-01T10:14:17.32+00:00

Hi,

I would like to create Azure SQL DB and user can access tables inside it without any credentials (Anonymous). I knew we can create REST API and use it as an Anonymous.

Is it possible in Azure SQL?

Thanks,
Samir

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Navtej Singh Saini 4,226 Reputation points Microsoft Employee
    2020-09-04T01:41:11.113+00:00

    @Samir KHIMANI

    The use of the Guest user as available in the On Prem SQL is not possible in Azure SQL. There are other methods for achieving this and you can look into Token Authentication.

    The token-based authentication method allows middle-tier services to obtain a token from Azure AD and use it to connect to Azure SQL Database. It enables more sophisticated scenarios, including certificate-based authentication. The above link has a working example as well that you can check.

    Hope this helps. If you have a specific scenario that you need help with, Please do share so that we can look into the same.

    Thanks
    Navtej S

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.