Share via

Database Connection Policies - Get

  • Reference
Service:
SQL Database
API Version:
2014-04-01

Gets a database's connection policy, which is used with table auditing. Table auditing is deprecated, use blob auditing instead.

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/connectionPolicies/default?api-version=2014-04-01

URI Parameters

Name In Required Type Description
connectionPolicyName
 path True

ConnectionPolicyName

The name of the connection policy.
databaseName
 path True

string

The name of the database for which the connection policy is defined.
resourceGroupName
 path True

string

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
serverName
 path True

string

The name of the server.
subscriptionId
 path True

string

The subscription ID that identifies an Azure subscription.
api-version
 query True

string

The API version to use for the request.

Responses

Name Type Description
200 OK

DatabaseConnectionPolicy

Successfully retrieved the database connection policy.

Examples

Get database table auditing policy

Sample request

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/blobauditingtest-6852/providers/Microsoft.Sql/servers/blobauditingtest-2080/databases/testdb/connectionPolicies/default?api-version=2014-04-01

Sample response

Status code:
200 
{
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/blobauditingtest-6852/providers/Microsoft.Sql/servers/blobauditingtest-2080/databases/testdb/connectionPolicies/default",
  "name": "default",
  "type": "Microsoft.Sql/servers/databases/connectionPolicies",
  "location": "West US",
  "kind": null,
  "properties": {
    "securityEnabledAccess": "Optional",
    "proxyDnsName": "blobauditingtest-2080.database.secure.windows.net",
    "proxyPort": "1433",
    "visibility": "Visible",
    "useServerDefault": "Enabled",
    "redirectionState": "Disabled",
    "state": "New"
  }
}

Definitions

Name Description
ConnectionPolicyName

The name of the connection policy.
DatabaseConnectionPolicy

A database connection policy.

ConnectionPolicyName

The name of the connection policy.

Name Type Description
default

string

DatabaseConnectionPolicy

A database connection policy.

Name Type Description
id

string

Resource ID.
kind

string

Resource kind.
location

string

Resource location.
name

string

Resource name.
properties.proxyDnsName

string

The fully qualified host name of the auditing proxy.
properties.proxyPort

string

The port number of the auditing proxy.
properties.redirectionState

string

The state of proxy redirection.
properties.securityEnabledAccess

string

The state of security access.
properties.state

string

The connection policy state.
properties.useServerDefault

string

Whether server default is enabled or disabled.
properties.visibility

string

The visibility of the auditing proxy.
type

string

Resource type.