Queries the whitelist of a ContextDB-X instance.
Operation description
The SQL audit and analysis feature of PolarDB-X 2.0 is free of charge. However, Simple Log Service charges fees for storage space, read traffic, number of requests, data transformation, and data shipping. For more information about the SQL audit feature, see Enable SQL audit and analysis.
Try it now
Test
RAM authorization
Request parameters
|
Parameter |
Type |
Required |
Description |
Example |
| RegionId |
string |
Yes |
The region ID. |
cn-hangzhou |
| DBInstanceName |
string |
Yes |
The instance ID. |
pxc-hzjasd**** |
Response elements
|
Element |
Type |
Description |
Example |
|
object |
|||
| RequestId |
string |
The request ID. |
D6A4256F-7B83-5BD7-9AC0-72E1FAC05330 |
| Data |
object |
The paginated result of the instance list. |
|
| DBInstanceName |
string |
The instance name. |
pxc-********* |
| ContextDBInstanceName |
string |
The context service instance name. |
pxt-********* |
| GroupItems |
array<object> |
The whitelist group list. |
|
|
object |
The whitelist group list. |
||
| GroupName |
string |
defaultGroup |
|
| SecurityIPList |
string |
127.0.0.1,172.168.0.0 |
|
| GroupTag |
string |
group1 |
|
| AccessDeniedDetail |
object |
The details of the access denial. |
|
| AuthAction |
string |
The authentication action. |
xxx |
| AuthPrincipalType |
string |
The authentication principal type. |
222 |
| AuthPrincipalOwnerId |
string |
The owner ID of the authentication principal. |
111 |
| AuthPrincipalDisplayName |
string |
The display name of the authentication principal. |
xxx |
| PolicyType |
string |
The policy type. |
PRIORITY |
| NoPermissionType |
string |
NoPermissionType |
ImplicitDeny |
| EncodedDiagnosticMessage |
string |
The diagnostic information. |
AQEAAAAAaKPfwjY0MzMyODRGLUZCQkQtNTA1RS04MUUxLTc5NTkzODk2MUIzMg== |
Examples
Success response
JSON format
{
"RequestId": "D6A4256F-7B83-5BD7-9AC0-72E1FAC05330",
"Data": {
"DBInstanceName": "pxc-*********",
"ContextDBInstanceName": "pxt-*********",
"GroupItems": [
{
"GroupName": "defaultGroup",
"SecurityIPList": "127.0.0.1,172.168.0.0",
"GroupTag": "group1"
}
]
},
"AccessDeniedDetail": {
"AuthAction": "xxx",
"AuthPrincipalType": "222",
"AuthPrincipalOwnerId": "111",
"AuthPrincipalDisplayName": "xxx",
"PolicyType": "PRIORITY",
"NoPermissionType": "ImplicitDeny",
"EncodedDiagnosticMessage": "AQEAAAAAaKPfwjY0MzMyODRGLUZCQkQtNTA1RS04MUUxLTc5NTkzODk2MUIzMg=="
}
}Error codes
See Error Codes for a complete list.
Release notes
See Release Notes for a complete list.