Azure SQL PIM access

Aluri, Sirisha 1 Reputation point

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?

  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.

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 29,886 Reputation points MVP

    Currently there is no method for using the PIM for Azure SQL at the moment.
    Its based on the below access parts:
    To grant access to users

    @Alberto Morillo :please correct me if I am wrong