Azure SQL Management

Microsoft Azure SQL Management Integration manages the Auditing and Threat Policies for Azure SQL.

IT Services · Azure SQL Management

Configuration parameters

  • app_id — Application ID
  • subscription_id — Default Subscription ID
  • resource_group_name — Default Resource Group Name
  • auth_type — Authentication Type (required)
  • tenant_id — Tenant ID
  • credentials — Client Secret
  • redirect_uri — Application redirect URI (for authorization code mode)
  • auth_code — Authorization code
  • managed_identities_client_id —
  • azure_ad_endpoint — Azure AD endpoint
  • insecure — Trust any certificate (not secure)
  • proxy — Use system proxy settings

Commands (17)

  • azure-sql-auth-complete

    Run this command to complete the authorization process. Should be used after running the azure-sql-auth-start command.

  • azure-sql-auth-reset

    Run this command if for some reason you need to rerun the authentication process.

  • azure-sql-auth-start

    Run this command to start the authorization process and follow the instructions in the command results.

  • azure-sql-auth-test

    Tests the connectivity to the Azure SQL Management.

  • azure-sql-db-audit-policy-create-update

    Creates or updates the database's auditing policy.

  • azure-sql-db-audit-policy-list

    Gets the audit settings of the specified database.

  • azure-sql-db-list

    Lists all of the databases for the server.

  • azure-sql-db-threat-policy-create-update

    Creates or updates the database's threat detection policy.

  • azure-sql-db-threat-policy-get

    Gets the threat detection policy of the specified database.

  • azure-sql-firewall-rule-create-update

    Creates or updates a firewall rule. Required Permissions: Microsoft.Sql/servers/firewallRules/write.

  • azure-sql-firewall-rule-delete

    Deletes a firewall rule. Required Permissions: Microsoft.Sql/servers/firewallRules/delete.

  • azure-sql-firewall-rule-list

    Retrieves a list of firewall rules or a specific firewall rule. Required Permissions: Microsoft.Sql/servers/firewallRules/read.

  • azure-sql-firewall-rule-replace

    Replaces all firewall rules on the server. Required Permissions: Microsoft.Sql/servers/firewallRules/write.

  • azure-sql-generate-login-url

    Generate the login url used for Authorization code flow.

  • azure-sql-resource-group-list

    Gets all the resource groups for a subscription.

  • azure-sql-servers-list

    Lists all the servers.

  • azure-sql-subscriptions-list

    Gets all subscriptions for a tenant.