forked from docs/doc-exports
Wang , Deng Ke
60010eb9d0
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com> Co-authored-by: Wang , Deng Ke <wangdengke2@huawei.com> Co-committed-by: Wang , Deng Ke <wangdengke2@huawei.com>
91 lines
6.7 KiB
HTML
91 lines
6.7 KiB
HTML
<a name="dds_api_0098"></a><a name="dds_api_0098"></a>
|
|
|
|
<h1 class="topictitle1">Querying SQL Audit Policy</h1>
|
|
<div id="body0000001072036540"><div class="section" id="dds_api_0098__section4850156117316"><h4 class="sectiontitle">Function</h4><p id="dds_api_0098__p3631239417316">This API is used to query the policy for SQL audit logs.</p>
|
|
</div>
|
|
<div class="section" id="dds_api_0098__section28961517113719"><h4 class="sectiontitle">URI</h4><ul id="dds_api_0098__ul3084351717316"><li id="dds_api_0098__li915620217316">URI format<p id="dds_api_0098__p912862005412"><a name="dds_api_0098__li915620217316"></a><a name="li915620217316"></a>GET https://{Endpoint}/v3/{project_id}/instances/{instance_id}/auditlog-policy</p>
|
|
</li><li id="dds_api_0098__li15430535">Parameter description
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="dds_api_0098__table4657088" frame="border" border="1" rules="all"><caption><b>Table 1 </b>Parameter description</caption><thead align="left"><tr id="dds_api_0098__row60083059"><th align="left" class="cellrowborder" valign="top" width="24%" id="mcps1.3.2.2.2.1.2.4.1.1"><p id="dds_api_0098__p34889605">Name</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="24.9%" id="mcps1.3.2.2.2.1.2.4.1.2"><p id="dds_api_0098__p7485743">Mandatory</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="51.1%" id="mcps1.3.2.2.2.1.2.4.1.3"><p id="dds_api_0098__p2775334615440">Description</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="dds_api_0098__row57385070"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.2.2.2.1.2.4.1.1 "><p id="dds_api_0098__p732920567115">project_id</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="24.9%" headers="mcps1.3.2.2.2.1.2.4.1.2 "><p id="dds_api_0098__p532935613116">Yes</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="51.1%" headers="mcps1.3.2.2.2.1.2.4.1.3 "><p id="dds_api_0098__p4329756415">Specifies the project ID of a tenant in a region.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dds_api_0098__row2864326155157"><td class="cellrowborder" valign="top" width="24%" headers="mcps1.3.2.2.2.1.2.4.1.1 "><p id="dds_api_0098__p963319528116">instance_id</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="24.9%" headers="mcps1.3.2.2.2.1.2.4.1.2 "><p id="dds_api_0098__p1032910565114">Yes</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="51.1%" headers="mcps1.3.2.2.2.1.2.4.1.3 "><p id="dds_api_0098__p15330656516">Specifies the instance ID, which can be obtained by calling the API for querying instances. If you do not have an instance, you can call the API used for creating an instance.</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</li></ul>
|
|
</div>
|
|
<div class="section" id="dds_api_0098__section3074340117316"><h4 class="sectiontitle">Requests</h4><ul id="dds_api_0098__ul12680111313533"><li id="dds_api_0098__li8680161314538">Example request<p id="dds_api_0098__p1559931617531"><a name="dds_api_0098__li8680161314538"></a><a name="li8680161314538"></a>GET https://dds.eu-de.otc.t-systems.com/v3/0549b4a43100d4f32f51c01c2fe4acdb/instances/5cecca4c20e04146862651b8d385f26ain02/auditlog-policy</p>
|
|
</li></ul>
|
|
</div>
|
|
<div class="section" id="dds_api_0098__section158075281284"><h4 class="sectiontitle">Responses</h4><ul id="dds_api_0098__ul168071728112818"><li id="dds_api_0098__li118075286284">Parameter description
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="dds_api_0098__table1980892892819" frame="border" border="1" rules="all"><caption><b>Table 2 </b>Parameter description</caption><thead align="left"><tr id="dds_api_0098__row6808182818282"><th align="left" class="cellrowborder" valign="top" width="28.442844284428443%" id="mcps1.3.4.2.1.1.2.4.1.1"><p id="dds_api_0098__p080812812289">Name</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="24.412441244124413%" id="mcps1.3.4.2.1.1.2.4.1.2"><p id="dds_api_0098__p5808128112818">Type</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="47.14471447144714%" id="mcps1.3.4.2.1.1.2.4.1.3"><p id="dds_api_0098__p1980822842816">Description</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="dds_api_0098__row6808142852819"><td class="cellrowborder" valign="top" width="28.442844284428443%" headers="mcps1.3.4.2.1.1.2.4.1.1 "><p id="dds_api_0098__p20808132842820">keep_days</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="24.412441244124413%" headers="mcps1.3.4.2.1.1.2.4.1.2 "><p id="dds_api_0098__p9808112812820">Integer</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="47.14471447144714%" headers="mcps1.3.4.2.1.1.2.4.1.3 "><p id="dds_api_0098__p11809172802813">Indicates the number of days for storing audit logs. The value is <strong id="dds_api_0098__b1780932852815">0</strong> when SQL audit is disabled.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dds_api_0098__row19809528102817"><td class="cellrowborder" valign="top" width="28.442844284428443%" headers="mcps1.3.4.2.1.1.2.4.1.1 "><p id="dds_api_0098__p1880982882811">audit_scope</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="24.412441244124413%" headers="mcps1.3.4.2.1.1.2.4.1.2 "><p id="dds_api_0098__p58092283289">String</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="47.14471447144714%" headers="mcps1.3.4.2.1.1.2.4.1.3 "><p id="dds_api_0098__p1809142832816">Indicates the audit scope.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dds_api_0098__row18092286285"><td class="cellrowborder" valign="top" width="28.442844284428443%" headers="mcps1.3.4.2.1.1.2.4.1.1 "><p id="dds_api_0098__p480962882811">audit_types</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="24.412441244124413%" headers="mcps1.3.4.2.1.1.2.4.1.2 "><p id="dds_api_0098__p1280912284286">Array of strings</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="47.14471447144714%" headers="mcps1.3.4.2.1.1.2.4.1.3 "><p id="dds_api_0098__p6809142812816">Indicates the audit type.</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</li></ul>
|
|
<ul id="dds_api_0098__ul78094284287"><li id="dds_api_0098__li1180912280289">Response example<pre class="codeblock" id="dds_api_0098__codeblock14809528162812">{
|
|
"keep_days":7,
|
|
"audit_scope":"all",
|
|
"audit_types":["insert"]
|
|
}</pre>
|
|
</li></ul>
|
|
</div>
|
|
<div class="section" id="dds_api_0098__section5382712154838"><h4 class="sectiontitle">Status Code</h4><p id="dds_api_0098__dds_api_0018_p16131712193312">Status Code:200.</p>
|
|
<p id="dds_api_0098__dds_api_0018_p480617135329">For more information, see <a href="dds_status_code.html">Status Code</a>.</p>
|
|
</div>
|
|
<div class="section" id="dds_api_0098__section6522193710339"><h4 class="sectiontitle">Error Code</h4><p id="dds_api_0098__dds_api_0018_p20466124120334">For more information, see <a href="dds_error_code.html">Error Code</a>.</p>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dds_api_0092.html">Log Information Queries</a></div>
|
|
</div>
|
|
</div>
|
|
|