Private Link for Azure PaaS DB | User Access through RBAC

PK 326 Reputation points
2021-11-18T03:18:30.533+00:00

Team,

I wanted to secure my Azure PaaS SQL Database through Private Link.

Only through the private link, the API should be able to access the database. Now, if I had setup private link, would I be able to setup RBAC for the developers to connect to the database?

How to implement these two:

1) Private link to access Azure PaaS database.
2) RBAC for the developers to Azure PaaS database.

Thanks,
PK

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Oury Ba-MSFT 20,341 Reputation points Microsoft Employee
    2021-11-22T17:25:38.193+00:00

    Hi PK-7858 Thank you for posting your Question on Microsoft Q&A and sorry for the late reply

    Azure Private Link enables you to access Azure PaaS Services (for example, Azure Storage and SQL Database) and Azure hosted customer-owned/partner services over a private endpoint in your virtual network.

    How to create a private link to access Azure PaaS Database

    You will also be able to det up RBAC for the developers to connect to your database. Private link only removes the need to open SQL firewall for specific IPs

    https://learn.microsoft.com/en-us/azure/azure-sql/database/logins-create-manage

    Please let us know if you need additional clarification.

    Regards,
    Oury

    0 comments No comments

0 additional answers

Sort by: Most helpful

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.