question

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

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
10 |1000 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 ·

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 · Share
10 |1000 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.