question

coderbn-2970 avatar image
0 Votes"
coderbn-2970 asked coderbn-2970 commented

Azure SQL PIM like access

I wanted to set-up something like a PIM access to Azure SQL but upon reading some docs/article, it's mostly adding a user to an AD Group or to the Azure SQL database itself.

Is there a way to do PIM or like that for Azure SQL or any of the Azure Databases?
Requirements:
1. no user has default access to the database
2. user need to request access and be removed based on duration automatically
3. audit of the users requesting access to the database

Looking forward to your reply.
Thanks.

azure-sql-databaseazure-ad-privileged-identity-management
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered coderbn-2970 commented

Hi @coderbn-2970


Currently there is no method for using the PIM for Azure SQL at the moment. Please provide your feedback on Azure SQL user voice . Product team will look into these and provide insight.


The current methods for connections are 1) Users and logins and 2) AD integration .


Please review these documents to check the method you can implement. Please let us know if you have further questions about this.


Thanks
Navtej S



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.