Azure SQL PIM access

Aluri, Sirisha 1 Reputation point
2022-08-18T08:51:46.153+00:00

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 Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 29,886 Reputation points MVP
    2022-08-18T14:19:30.927+00:00

    Hey,
    Currently there is no method for using the PIM for Azure SQL at the moment.
    Its based on the below access parts:
    https://learn.microsoft.com/en-us/azure/azure-sql/database/logins-create-manage?view=azuresql
    https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview?view=azuresql
    To grant access to users

    @Alberto Morillo :please correct me if I am wrong