Azure SQL Management
Microsoft Azure SQL Management Integration manages the Auditing and Threat Policies for Azure SQL.
- Category
- IT Services
- Pack
- AzureSQLManagement
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.