{"id":168,"date":"2020-06-09T15:09:08","date_gmt":"2020-06-09T07:09:08","guid":{"rendered":"http:\/\/www.gbase8.cn\/?p=168"},"modified":"2023-04-23T12:56:19","modified_gmt":"2023-04-23T04:56:19","slug":"gbase-8a%e9%9b%86%e7%be%a4%e5%ae%a1%e8%ae%a1%e6%97%a5%e5%bf%97%e6%94%bb%e7%95%a5%e5%92%8c%e4%bd%bf%e7%94%a8%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/168","title":{"rendered":"Nanda General GBase 8a Cluster Audit Log audit_log Guide and Usage"},"content":{"rendered":"\n<p>GBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\u63d0\u4f9b\u4e86\u5ba1\u8ba1\u65e5\u5fd7audit_log\uff0c\u8bb0\u5f55\u6570\u636e\u5e93\u6267\u884c\u7684\u6240\u6709SQL\u3002\u901a\u8fc7\u53c2\u6570\u6216\u5ba1\u8ba1\u7b56\u7565\uff0c\u4fdd\u7559\u7b26\u5408\u6761\u4ef6\u7684\u65e5\u5fd7\u5230\u6587\u4ef6\u6216\u8868\u91cc\u3002<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u76ee\u5f55\u5bfc\u822a<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2a9d572fbdf\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2a9d572fbdf\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E4%BD%9C%E7%94%A8\" >\u4f5c\u7528<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E5%AD%98%E5%82%A8%E8%BF%87%E7%A8%8B%E7%9A%84%E5%AE%A1%E8%AE%A1%E6%97%A5%E5%BF%97\" >\u5b58\u50a8\u8fc7\u7a0b\u7684\u5ba1\u8ba1\u65e5\u5fd7<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E6%B3%A8%E6%84%8F\" >\u6ce8\u610f<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E4%BD%BF%E7%94%A8%E6%96%B9%E6%B3%95\" >\u4f7f\u7528\u65b9\u6cd5<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E5%8F%AA%E5%BC%80gcluster%E5%B1%82%E5%AE%A1%E8%AE%A1%E7%9A%84%E6%96%B9%E6%B3%95\" >\u53ea\u5f00gcluster\u5c42\u5ba1\u8ba1\u7684\u65b9\u6cd5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E4%B8%B4%E6%97%B6%E4%BD%BF%E7%94%A8%EF%BC%9A\" >\u4e34\u65f6\u4f7f\u7528\uff1a<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E9%95%BF%E6%9C%9F%E4%BD%BF%E7%94%A8%EF%BC%9A\" >\u957f\u671f\u4f7f\u7528\uff1a<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E5%AE%A1%E8%AE%A1%E7%AD%96%E7%95%A5\" >\u5ba1\u8ba1\u7b56\u7565<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E4%BD%BF%E7%94%A8%E6%A0%B7%E4%BE%8B\" >\u4f7f\u7528\u6837\u4f8b<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E6%89%93%E5%BC%80%E5%AE%A1%E8%AE%A1%E6%97%A5%E5%BF%97\" >\u6253\u5f00\u5ba1\u8ba1\u65e5\u5fd7<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E5%88%9B%E5%BB%BA%E8%AE%B0%E5%BD%95%E6%89%80%E6%9C%89%E6%93%8D%E4%BD%9C%E7%9A%84%E5%AE%A1%E8%AE%A1%E7%AD%96%E7%95%A5\" >\u521b\u5efa\u8bb0\u5f55\u6240\u6709\u64cd\u4f5c\u7684\u5ba1\u8ba1\u7b56\u7565<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E5%88%9B%E5%BB%BA%E9%99%A4%E4%BA%86SELECT%E5%92%8COTHER%E4%B9%8B%E5%A4%96%E7%9A%84DML%E5%92%8CDDL%E7%9A%84%E5%AE%A1%E8%AE%A1%E7%AD%96%E7%95%A5\" >\u521b\u5efa\u9664\u4e86SELECT\u548cOTHER\u4e4b\u5916\u7684DML\u548cDDL\u7684\u5ba1\u8ba1\u7b56\u7565<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E5%88%9B%E5%BB%BA%E8%AE%B0%E5%BD%95%E7%89%B9%E5%AE%9ASQL%E7%9A%84%E5%AE%A1%E8%AE%A1%E7%AD%96%E7%95%A5\" >\u521b\u5efa\u8bb0\u5f55\u7279\u5b9aSQL\u7684\u5ba1\u8ba1\u7b56\u7565<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E9%92%88%E5%AF%B9%E7%89%B9%E5%AE%9A%E8%A1%A8%E7%9A%84%E5%AE%A1%E8%AE%A1%E7%AD%96%E7%95%A5\" >\u9488\u5bf9\u7279\u5b9a\u8868\u7684\u5ba1\u8ba1\u7b56\u7565<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E5%AE%A1%E8%AE%A1%E7%AD%96%E7%95%A5%E5%8F%82%E6%95%B0%E4%BF%AE%E6%94%B9\" >\u5ba1\u8ba1\u7b56\u7565\u53c2\u6570\u4fee\u6539<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E5%AE%A1%E8%AE%A1%E7%AD%96%E7%95%A5%E5%88%A0%E9%99%A4\" >\u5ba1\u8ba1\u7b56\u7565\u5220\u9664<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E5%AE%A1%E8%AE%A1%E6%97%A5%E5%BF%97TABLE%E6%A0%BC%E5%BC%8F%E7%9A%84%E6%A0%B7%E4%BE%8B\" >\u5ba1\u8ba1\u65e5\u5fd7TABLE\u683c\u5f0f\u7684\u6837\u4f8b<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E5%AE%A1%E8%AE%A1%E6%97%A5%E5%BF%97%E6%96%87%E4%BB%B6%E6%A0%BC%E5%BC%8F%E7%9A%84%E6%A0%B7%E4%BE%8B\" >\u5ba1\u8ba1\u65e5\u5fd7\u6587\u4ef6\u683c\u5f0f\u7684\u6837\u4f8b<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E5%AE%A1%E8%AE%A1%E6%97%A5%E5%BF%97%E5%BD%92%E6%A1%A3\" >\u5ba1\u8ba1\u65e5\u5fd7\u5f52\u6863<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E7%99%BB%E5%BD%95%E5%AF%86%E7%A0%81%E9%94%99%E8%AF%AF%E8%AE%B0%E5%BD%95\" >\u767b\u5f55\u5bc6\u7801\u9519\u8bef\u8bb0\u5f55<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.gbase8.cn\/en\/168\/#%E6%89%A7%E8%A1%8C%E8%AF%AD%E6%B3%95%E9%94%99%E8%AF%AF%E7%9A%84SQL\" >\u6267\u884c\u8bed\u6cd5\u9519\u8bef\u7684SQL<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%BD%9C%E7%94%A8\"><\/span>\u4f5c\u7528<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u8bb0\u5f55\u96c6\u7fa4\u6240\u6709\u6267\u884c\u5b8c\u6210\u7684SQL,\u5305\u62ec\u7528\u6237\u767b\u5f55\u5931\u8d25\uff0cSQL\u8bed\u6cd5\u9519\u8bef\u7b49\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%AD%98%E5%82%A8%E8%BF%87%E7%A8%8B%E7%9A%84%E5%AE%A1%E8%AE%A1%E6%97%A5%E5%BF%97\"><\/span>\u5b58\u50a8\u8fc7\u7a0b\u7684\u5ba1\u8ba1\u65e5\u5fd7<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5b58\u50a8\u8fc7\u7a0b\u7684\u521b\u5efa\u662fDDL\uff0c\u53ef\u4ee5\u8bb0\u5f55\u5b8c\u6574\u7684SQL\u8bed\u53e5\u3002<\/p>\n\n\n\n<p>\u5b58\u50a8\u8fc7\u7a0b\u6267\u884c\u65f6\uff0c\u5ba1\u8ba1\u65e5\u5fd7\u53ea\u8bb0\u5f55call \u7684SQL,\u4e0d\u8bb0\u5f55\u5185\u90e8\u7684\u6bcf\u4e2aSQL\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%B3%A8%E6%84%8F\"><\/span>\u6ce8\u610f<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>\u9ed8\u8ba4\u7684\u5ba1\u8ba1\u65e5\u5fd7\uff0c\u4ee5FILE\u5f62\u5f0f\uff0c\u4fdd\u5b58\u5728audit_log_file\u53c2\u6570\u6307\u5b9a\u7684\u76ee\u5f55\u4e0b\uff0c\u9ed8\u8ba4\u662f\u662fgcluster\/log\/gcluster\/gclusterd-audit.log. \u5982\u679c\u4ee5TABLE\u65b9\u5f0f\u8bb0\u5f55\u65f6\uff0c\u662f\u4fdd\u5b58\u5728gbase.audit_log\u8868\u91cc\u9762\u3002<\/li><li>\u5ba1\u8ba1\u65e5\u5fd7\u53ea\u8bb0\u5f55\u5728\u5f53\u524d\u8282\u70b9\u8fd0\u884c\u7684SQL\uff0c\u5982\u679c\u4f60\u8981\u770b\u6574\u4e2a\u96c6\u7fa4\u7684SQL,\u9700\u8981\u9010\u4e2a\u8bbf\u95ee\u6bcf\u4e2a\u8282\u70b9\u3002<\/li><li>\u5ba1\u8ba1\u65e5\u5fd7\u5206\u7ba1\u7406\u8282\u70b9(gcluster)\u548c\u6570\u636e\u8282\u70b9(gnode)\uff0c\u5176\u4e2d\u7ba1\u7406\u8282\u70b9\u662f\u4fdd\u5b58\u5916\u90e8\u4f20\u6765\u7684SQL,\u800cgnode\u4fdd\u5b58\u7684\u662f\u5185\u90e8\uff08\u7ba1\u7406\u8282\u70b9\u4e0b\u53d1\uff09\u7684SQL\u3002<\/li><li>\u5ba1\u8ba1\u65e5\u5fd7\u5f52\u6863\u3002\u7531\u4e8egbase.audit_log\u8868\u80fd\u4fdd\u5b58\u7684\u6570\u636e\u884c\u6570\u6709\u9650\uff0c\u4e00\u822c\u8d85\u8fc7\u5343\u4e07\u884c\u5c31\u7ecf\u5e38\u62a5\u9519\uff0c\u6240\u4ee5\u65b0\u7248\u96c6\u7fa4(862B33\u4ee5\u540e)\u90fd\u9ed8\u8ba4\u63d0\u4f9b\u4e86\u4e00\u4e2a\u5ba1\u8ba1\u65e5\u5fd7\u5f52\u6863\u529f\u80fd\uff08\u5177\u4f53\u770b\u540e\u9762\u7684\u7ae0\u8282\uff09\u3002\u6bcf\u4e2a\u3010\u7ba1\u7406\u8282\u70b9\u3011\u7684\u5ba1\u8ba1\u65e5\u5fd7\u4f1a\u81ea\u52a8\u5f52\u6863\u5230\u4e00\u4e2a\u96c6\u7fa4\u8868\u91cc\u9762\uff0c\u9ed8\u8ba4\u662fgclusterdb.audit_log_express\u8868\u3002\u6240\u4ee5\u5982\u679c\u67e5\u8be2\u5386\u53f2\u5ba1\u8ba1\u65e5\u5fd7\uff0c\u8bf7\u4ece\u8fd9\u4e2a\u96c6\u7fa4\u8868\u91cc\u67e5\u8be2\uff0c\u5f53\u524d\u7684\u6700\u8fd1\u3010\u5f52\u6863\u5468\u671f\u3011\u5185\u7684\u5728gbase.audit_log\u91cc\u3002 \u5f52\u6863\u5468\u671f\u5728event\u91cc\u7531\u7528\u6237\u81ea\u884c\u6307\u5b9a\u3002<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%BD%BF%E7%94%A8%E6%96%B9%E6%B3%95\"><\/span>\u4f7f\u7528\u65b9\u6cd5<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u6ce8\u610f\uff1a\u5ba1\u8ba1\u65e5\u5fd7\u4e00\u822c\u90fd\u662f\u5bf9\u5916\u90e8SQL\u7684\u5ba1\u8ba1\uff0c\u6240\u4ee5\u90fd\u53ea\u5efa\u8bae\u5f00\u542fgcluster\u5c42\u7684\u5373\u53ef\u3002<\/p>\n\n\n\n<p>\u65b0\u7248\u96c6\u7fa4862B33+ \u6709\u5ba1\u8ba1\u7b56\u7565\u529f\u80fd\uff0c\u8bf7\u770b\u540e\u7eed\u7684\u7ae0\u8282\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%8F%AA%E5%BC%80gcluster%E5%B1%82%E5%AE%A1%E8%AE%A1%E7%9A%84%E6%96%B9%E6%B3%95\"><\/span>\u53ea\u5f00gcluster\u5c42\u5ba1\u8ba1\u7684\u65b9\u6cd5<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u8be5\u65b9\u6cd5\u9002\u5408\u540e\u9762\u6240\u6709\u64cd\u4f5c\uff0c\u8bf7\u53c2\u8003\u6267\u884c\u3002<\/p>\n\n\n\n<p>1\u3001\u6700\u7b80\u5355\u7684\u662f\u5728\u7ba1\u7406\u8282\u70b9\u914d\u7f6e\u5ba1\u8ba1\u65e5\u5fd7\u53c2\u6570\uff0c\u7136\u540e\u91cd\u542f<\/p>\n\n\n\n<p>2\u3001\u5982\u679c\u4e0d\u60f3\u91cd\u542f\uff0c\u5219\u9700\u8981\u5982\u4e0b\u64cd\u4f5c<\/p>\n\n\n\n<p>a\u3001\u5728\u96c6\u7fa4\u5c42gccli\u6253\u5f00\u6240\u6709\u5ba1\u8ba1\u65e5\u5fd7\uff0c\u5fc5\u987b\u662fglobal\u7684\u3002\u8fd9\u6837\u6240\u6709\u8282\u70b9\uff0c\u5305\u62ec\u7ba1\u7406\u548c\u6570\u636e\u7684\u90fd\u6253\u5f00\u4e86\u3002<\/p>\n\n\n\n<p>b\u3001\u6328\u4e2a\u8fde\u63a5\u6570\u636e\u8282\u70b9\uff0c gncli ,\u5173\u95ed\u5ba1\u8ba1\u65e5\u5fd7 \u4e5f\u662fglobal\u7684\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%B8%B4%E6%97%B6%E4%BD%BF%E7%94%A8%EF%BC%9A\"><\/span><strong>\u4e34\u65f6\u4f7f\u7528<\/strong>\uff1a<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u4f7f\u7528\u96c6\u7fa4\u5ba2\u6237\u7aef gccli<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; set global audit_log=1;\ngbase&gt; set global log_output='table';\ngbase&gt; set global long_query_time=0;<\/code><\/pre>\n\n\n\n<p>\u5982\u4e0a\u64cd\u4f5c\u540c\u65f6\u6253\u5f00\u4e86gcluster\u548cgnode\u7684\u5ba1\u8ba1\u65e5\u5fd7\uff0cgnode\u65e5\u5fd7\u4f1a\u975e\u5e38\u591a\uff0c\u4e0d\u5efa\u8bae\u4f7f\u7528\u3002<\/p>\n\n\n\n<p>\u7b2c\u4e00\u884c\u662f\u6253\u5f00\u5ba1\u8ba1\u65e5\u5fd7\u529f\u80fd\u30021\u662f\u6253\u5f00\uff0c0\u662f\u5173\u95ed\u3002<\/p>\n\n\n\n<p>\u7b2c\u4e8c\u884c\u662f\u5ba1\u8ba1\u65e5\u5fd7\u8bb0\u5f55\u5230\u6570\u636e\u5e93\u8868\u91cc\u9762\u3002\u9ed8\u8ba4\u662f\u6587\u4ef6\u3002<\/p>\n\n\n\n<p>\u7b2c\u4e09\u884c\u662f\u8bb0\u5f55SQL\u6267\u884c\u65f6\u95f4\u9608\u503c\uff0c\u5355\u4f4d\u79d2\u3002\u5927\u4e8e\u7b49\u4e8e\u8fd9\u4e2a\u503c\u7684\u624d\u8bb0\u5f55\u30020\u7b49\u4e8e\u5168\u90e8\u8bb0\u5f55\u3002\u5efa\u8bae\u6027\u80fd\u6392\u67e5\u65f6\u8bbe\u5b9a\u66f4\u9ad8\u7684\u503c\u3002\u9ed8\u8ba410\u79d2\u3002<\/p>\n\n\n\n<p>\u67e5\u8be2\u65f6\u4ecegbase.audit_log\u6570\u636e\u5e93\u67e5\u770b\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E9%95%BF%E6%9C%9F%E4%BD%BF%E7%94%A8%EF%BC%9A\"><\/span><strong>\u957f\u671f\u4f7f\u7528<\/strong>\uff1a<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>&nbsp; \u8bf7\u4fee\u6539\u3010\u7ba1\u7406\u8282\u70b9gcluster\u3011\u914d\u7f6e\u6587\u4ef6\u53c2\u6570\uff0c\u653e\u5230[gbase]\u90e8\u5206\uff0c\u5e76\u91cd\u542f\u6570\u636e\u5e93\u670d\u52a1\u3002<\/p>\n\n\n\n<p>audit_log=1<\/p>\n\n\n\n<p>\u6ce8\u610f\u4e8b\u9879\uff1a<\/p>\n\n\n\n<p>1\u3001\u5982\u9700\u8981\u957f\u671f\u8bb0\u5f55\uff0c\u8bf7\u66f4\u6539\u914d\u7f6e\u6587\u4ef6\uff0c\u5b9e\u73b0\u96c6\u7fa4\u91cd\u542f\u540e\u4f9d\u7136\u751f\u6548\u3002<\/p>\n\n\n\n<p>2\u3001\u8bf7\u5b9a\u65f6\u68c0\u67e5\u8868\u884c\u6570\uff0c\u5982\u8d85\u8fc7\u5343\u4e07\u884c\uff0c\u5efa\u8bae\u5220\u9664\u6389\u3002truncate self table audit_log\u3002<\/p>\n\n\n\n<p>3\u3001\u5ba1\u8ba1\u65e5\u5fd7\u5206\u4e3a\u7ba1\u7406\u5c42\u548c\u8ba1\u7b97\u5c42\uff0c\u5982\u4e0a\u662f\u5168\u90e8\u6253\u5f00\u4e86\u3002\u5982\u6e05\u7406\u8981\u7ba1\u7406\u548c\u8ba1\u7b97\u90fd\u8981\u6e05\u7406\u3002<\/p>\n\n\n\n<p>4\u3001\u5ba1\u8ba1\u65e5\u5fd7\u662f\u8282\u70b9\u7ea7\u7684\uff0c\u53ea\u8bb0\u5f55\u4e86\u8fde\u63a5\u5230\u672c\u8282\u70b9\u6267\u884c\u7684SQL,\u6574\u4e2a\u96c6\u7fa4\u7684SQL\u8981\u67e5\u770b\u6bcf\u4e2a\u8282\u70b9\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%AE%A1%E8%AE%A1%E7%AD%96%E7%95%A5\"><\/span> \u5ba1\u8ba1\u7b56\u7565<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u57288.6.2Build33\u7b49\u65b0\u7248\u672c\u96c6\u7fa4\u91cc\uff0c\u5f15\u5165\u4e86\u5ba1\u8ba1\u7b56\u7565\u7684\u914d\u7f6e\uff0c\u53ef\u4ee5\u66f4\u7075\u6d3b\u7684\u914d\u7f6e\u9700\u8981\u5ba1\u8ba1\u5e76\u8bb0\u5f55\u7684\u5185\u5bb9\u3002\u8001\u7248\u672c\u6ca1\u6709\u8fd9\u4e2a\u529f\u80fd\u3002\u53ea\u6709\u5f00\u542f\u4e86\u5ba1\u8ba1\u7b56\u7565\uff0c\u624d\u4f1a\u771f\u6b63\u8bb0\u5f55\u65e5\u5fd7\u3002\u5176\u4e2d\u7684\u5404\u4e2a\u53c2\u6570\u90fd\u53ef\u4ee5\u5728\u521b\u5efa\u5ba1\u8ba1\u65e5\u5fd7\u65f6\u914d\u7f6e\uff0c\u5177\u4f53\u770b\u4ea7\u54c1\u300a<strong>\u7ba1\u7406\u5458\u624b\u518c\u300b<\/strong>\u3002<\/p>\n\n\n\n<p>\u53ea\u6709audit_log\u5f00\u5173\u53c2\u6570\uff0clog_output\u4fdd\u5b58\u7c7b\u578b\u662f\u9700\u8981\u5728\u96c6\u7fa4\u53c2\u6570\u8bbe\u7f6e\u7684\uff0c\u5176\u5b83\u7684\u90fd\u5728\u5ba1\u8ba1\u7b56\u7565\u91cc\u3002<\/p>\n\n\n\n<p><span class=\"has-inline-color has-luminous-vivid-orange-color\">\u5ba1\u8ba1\u7b56\u7565\u53ef\u4ee5\u521b\u5efa\u591a\u4e2a\uff0c\u5e76\u540c\u65f6\u751f\u6548\u3002<\/span><\/p>\n\n\n\n<p>CREATE AUDIT POLICY \u5ba1\u8ba1\u65e5\u5fd7\u540d\u5b57[(\u53c2\u6570=\u503c\uff0c\u53c2\u6570=\u503c)];<\/p>\n\n\n\n<p>\u53c2\u6570\u5217\u8868\u5982\u4e0b\uff0c\u53ef\u4ee5\u901a\u8fc7desc gbase.audit_policy\u770b\u5230\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\u9879\u76ee\u540d\u79f0<\/td><td>\u53d6\u503c&amp;\u542b\u4e49<\/td><\/tr><tr><td>Enable<\/td><td>Y\uff1a\u542f\u7528\uff0c\u9ed8\u8ba4\u503c<br>N\uff1a\u7981\u7528<\/td><\/tr><tr><td>Hosts<\/td><td>''\uff1a\u4e0d\u9650\u5236\uff0c\u9ed8\u8ba4\u4e0d\u9650\u5236\u3002<br>&lt;host&gt;:\u4e25\u683c\u5339\u914d host\uff0c\u652f\u6301\u7a7a\u683c''\u5206\u9694\u7684 host \u5217\u8868\uff0chost \u53ef\u4f7f\u7528'%' \u548c'_'\u505a\u901a\u914d\u7b26<\/td><\/tr><tr><td>User<\/td><td>''\uff1a\u4e0d\u9650\u5236\uff0c\u9ed8\u8ba4\u4e0d\u9650\u5236\u3002<br>&lt;user&gt;\uff1a\u4e25\u683c\u5339\u914d user\uff0c\u533a\u5206\u5927\u5c0f\u5199<\/td><\/tr><tr><td>Db<\/td><td>''\uff1a\u4e0d\u9650\u5236\uff0c\u9ed8\u8ba4\u4e0d\u9650\u5236\u3002<br>&lt;db&gt;:\u4e25\u683c\u5339\u914d<\/td><\/tr><tr><td>Obj_type<\/td><td>''\uff1a\u4e0d\u9650\u5236\uff0c\u9ed8\u8ba4\u4e0d\u9650\u5236\u3002<br>TABLE(VIEW)\uff1aObject \u4e3a\u8868\uff08\u89c6\u56fe\uff09<br>PROCEDURE\uff1aObject \u4e3a\u5b58\u50a8\u8fc7\u7a0b<br>FUNCTION\uff1aObject \u4e3a\u51fd\u6570<\/td><\/tr><tr><td>Object<\/td><td>''\uff1a\u4e0d\u9650\u5236\uff0c\u9ed8\u8ba4\u4e0d\u9650\u5236\u3002<br>&lt;object&gt;\uff1a\u5339\u914d Obj_type \u6307\u5b9a\u7684 object&nbsp;<\/td><\/tr><tr><td>Sql_commands<br><\/td><td>''\uff1a\u4e0d\u9650\u5236\uff0c\u9ed8\u8ba4\u4e0d\u9650\u5236\u3002<br>INSERT, DELETE, UPDATE, LOAD, <br>CREATE_USER, CREATE_DB, CREATE_TABLE, CREATE_VIEW, CREATE_INDEX, CREATE_PROCEDURE, CREATE_FUNCTION,<br> RENAME_USER, <br>ALTER_DB, ALTER_TABLE, ALTER_PROCEDURE, ALTER_FUNCTION, ALTER_EVENT, <br>DROP_USER, DROP_DB, DROP_TABLE, DROP_VIEW, DROP_INDEX, DROP_PROCEDURE, DROP_FUNCTION, DROP_EVENT, <br>TRUNCATE, GRANT, REVOKE, SELECT\uff0cOTHERS\uff1a<br>\u5176\u4e2d\u7684\u4e00\u79cd\u6216\u591a\u79cd\u7c7b\u578b\uff0c\u591a\u4e2a\u7c7b\u578b\u95f4\u4ee5\u9017\u53f7\u2018,\u2019\u8fde\u63a5\uff0c\u4e14\u4e0d\u6dfb\u52a0\u7a7a\u683c<\/td><\/tr><tr><td>Long_query_time<br><\/td><td>&lt;secs&gt;\uff1a\u6700\u5c0f\u67e5\u8be2\u79d2\u6570\uff0c\u53ef\u5e26 6 \u4f4d\u5c0f\u6570\uff0c\u7cbe\u786e\u5230\u5fae\u79d2\uff0c\u9ed8\u8ba4\u503c 0\uff0c\u53d6<br>\u503c\u8303\u56f4\u4e3a 0~31536000s<\/td><\/tr><tr><td>Status<\/td><td>''\uff1a\u4e0d\u9650\u5236\uff0c\u9ed8\u8ba4\u4e0d\u9650\u5236\u3002<br>SUCCESS\uff1a\u6267\u884c\u6210\u529f<br>FAILED\uff1a\u6267\u884c\u5931\u8d25<br><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; desc audit_policy;\n+-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+----------+-------+\n| Field           | Type                                                                                                                                                                                                                                                                                                                                                                                                                | Null | Key | Default  | Extra |\n+-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+----------+-------+\n| Name            | varchar(64)                                                                                                                                                                                                                                                                                                                                                                                                         | NO   | PRI |          |       |\n| Enable          | enum('Y','N')                                                                                                                                                                                                                                                                                                                                                                                                       | NO   |     | Y        |       |\n| Hosts           | varchar(512)                                                                                                                                                                                                                                                                                                                                                                                                        | NO   |     |          |       |\n| User            | varchar(16)                                                                                                                                                                                                                                                                                                                                                                                                         | NO   |     |          |       |\n| Db              | varchar(64)                                                                                                                                                                                                                                                                                                                                                                                                         | NO   |     |          |       |\n| Obj_type        | enum('','TABLE(VIEW)','PROCEDURE','FUNCTION')                                                                                                                                                                                                                                                                                                                                                                       | NO   |     |          |       |\n| Object          | varchar(64)                                                                                                                                                                                                                                                                                                                                                                                                         | NO   |     |          |       |\n| Sql_commands    | set('','INSERT','DELETE','UPDATE','LOAD','CREATE_USER','CREATE_DB', 'CREATE_TABLE','CREATE_VIEW',\n'CREATE_INDEX','CREATE_PROCEDURE','CREATE_FUNCTION', 'CREATE_EVENT','RENAME_USER','ALTER_DB','ALTER_TABLE','ALTER_PROCEDURE','ALTER_FUNCTION','ALTER_EVENT', 'DROP_USER','DROP_DB','DROP_TABLE','DROP_VIEW','DROP_INDEX','DROP_PROCEDURE','DROP_FUNCTION','DROP_EVENT','TRUNCATE','GRANT','REVOKE','SELECT','OTHERS') | NO   |     |          |       |\n| Long_query_time | decimal(18,6)                                                                                                                                                                                                                                                                                                                                                                                                       | NO   |     | 0.000000 |       |\n| Status          | enum('','SUCCESS','FAILED')                                                                                                                                                                                                                                                                                                                                                                                         | NO   |     |          |       |\n+-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+----------+-------+\n10 rows in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<p><strong><span class=\"has-inline-color has-luminous-vivid-orange-color\">\u6ce8\u610f\uff1a<\/span><\/strong><\/p>\n\n\n\n<p><em>\u5ba1\u8ba1\u7b56\u7565\uff0c\u9ed8\u8ba4\u53ea\u5728\u7ba1\u7406\u8282\u70b9\u6709\u6548\uff0c\u5728gnode\u4e0a\u662f\u4e0d\u4f1a\u521b\u5efa\u7684\uff0c\u6240\u4ee5\u867d\u7136gnode\u770b\u53c2\u6570audit_log\u662fon,\u4f46\u5176\u5e76\u4e0d\u8bb0\u5f55\u65e5\u5fd7\u3002\u5982\u679c\u4f60\u9700\u8981\u8bb0\u5f55\uff0c\u8bf7\u81ea\u884c\u5728\u5404\u4e2agnode\u8282\u70b9\u521b\u5efa\u5ba1\u8ba1\u7b56\u7565\u3002<\/em><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>sql_commands\u91cc\u7684OTHERS\uff0c\u5305\u542b\u4e86\u9664\u4e86\u5982\u4e0a\u5217\u51fa\u7684\uff0c\u6240\u6709\u5176\u5b83\u7684\uff0c\u6bd4\u5982connect\uff0cquit,\uff0cset\uff0ckill\uff0cshow\u7b49\u7b49\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%BD%BF%E7%94%A8%E6%A0%B7%E4%BE%8B\"><\/span>\u4f7f\u7528\u6837\u4f8b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%89%93%E5%BC%80%E5%AE%A1%E8%AE%A1%E6%97%A5%E5%BF%97\"><\/span>\u6253\u5f00\u5ba1\u8ba1\u65e5\u5fd7<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; set global audit_log=1;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.31)<\/code><\/pre>\n\n\n\n<p>-- \u786e\u8ba4\u5ba1\u8ba1\u65e5\u5fd7\u8f93\u51fa\u65b9\u5f0f\uff0c\u5c11\u91cf\u7684\u5efa\u8bae\u7528TABLE,\u5927\u91cf\u7684(\u8d85\u8fc7\u5343\u4e07\u884c)\u5efa\u8bae\u7528FILE\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; show variables like '%log_output%';\n+---------------+-------+\n| Variable_name | Value |\n+---------------+-------+\n| log_output    | FILE  |\n+---------------+-------+\n1 row in set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%9B%E5%BB%BA%E8%AE%B0%E5%BD%95%E6%89%80%E6%9C%89%E6%93%8D%E4%BD%9C%E7%9A%84%E5%AE%A1%E8%AE%A1%E7%AD%96%E7%95%A5\"><\/span>\u521b\u5efa\u8bb0\u5f55\u6240\u6709\u64cd\u4f5c\u7684\u5ba1\u8ba1\u7b56\u7565<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; create audit policy audit_ALL;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.03)\ngbase&gt; select * from gbase.audit_policy;\n+-----------+--------+-------+------+----+----------+--------+--------------+-----------------+--------+\n| Name      | Enable | Hosts | User | Db | Obj_type | Object | Sql_commands | Long_query_time | Status |\n+-----------+--------+-------+------+----+----------+--------+--------------+-----------------+--------+\n| audit_all | Y      |       |      |    |          |        |              |        0.000000 |        |\n+-----------+--------+-------+------+----+----------+--------+--------------+-----------------+--------+\n1 row in set (Elapsed: 00:00:00.01)<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%9B%E5%BB%BA%E9%99%A4%E4%BA%86SELECT%E5%92%8COTHER%E4%B9%8B%E5%A4%96%E7%9A%84DML%E5%92%8CDDL%E7%9A%84%E5%AE%A1%E8%AE%A1%E7%AD%96%E7%95%A5\"><\/span>\u521b\u5efa\u9664\u4e86SELECT\u548cOTHER\u4e4b\u5916\u7684DML\u548cDDL\u7684\u5ba1\u8ba1\u7b56\u7565<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>create audit policy p_dmlddl(sql_commands='INSERT,DELETE,UPDATE,LOAD,CREATE_USER,CREATE_DB,CREATE_TABLE,CREATE_VIEW,CREATE_INDEX,CREATE_PROCEDURE,CREATE_FUNCTION,CREATE_EVENT,RENAME_USER,ALTER_DB,ALTER_TABLE,ALTER_PROCEDURE,ALTER_FUNCTION,ALTER_EVENT,DROP_USER,DROP_DB,DROP_TABLE,DROP_VIEW,DROP_INDEX,DROP_PROCEDURE,DROP_FUNCTION,DROP_EVENT,TRUNCATE,GRANT,REVOKE')<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%9B%E5%BB%BA%E8%AE%B0%E5%BD%95%E7%89%B9%E5%AE%9ASQL%E7%9A%84%E5%AE%A1%E8%AE%A1%E7%AD%96%E7%95%A5\"><\/span>\u521b\u5efa\u8bb0\u5f55\u7279\u5b9aSQL\u7684\u5ba1\u8ba1\u7b56\u7565<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u672c\u4f8b\u53ea\u8bb0\u5f55\u67d0\u4e9bDDL\u64cd\u4f5c<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; create audit policy ddl_dml_policy(sql_commands='update,delete,drop_table,alter_table');\nQuery OK, 0 rows affected (Elapsed: 00:00:00.03)\ngbase&gt; select * from audit_policy;\n+----------------+--------+-------+------+----+----------+--------+--------------------------------------+-----------------+--------+\n| Name           | Enable | Hosts | User | Db | Obj_type | Object | Sql_commands                         | Long_query_time | Status |\n+----------------+--------+-------+------+----+----------+--------+--------------------------------------+-----------------+--------+\n| ddl_dml_policy | Y      |       |      |    |          |        | DELETE,UPDATE,ALTER_TABLE,DROP_TABLE |        0.000000 |        |\n+----------------+--------+-------+------+----+----------+--------+--------------------------------------+-----------------+--------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E9%92%88%E5%AF%B9%E7%89%B9%E5%AE%9A%E8%A1%A8%E7%9A%84%E5%AE%A1%E8%AE%A1%E7%AD%96%E7%95%A5\"><\/span>\u9488\u5bf9\u7279\u5b9a\u8868\u7684\u5ba1\u8ba1\u7b56\u7565<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; alter audit policy ap_all set(Obj_type='TABLE(VIEW)',object='t1');\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\n\ngbase&gt; select * from gbase.audit_policy;\n+--------+--------+-------+------+----+-------------+--------+--------------+-----------------+--------+\n| Name   | Enable | Hosts | User | Db | Obj_type    | Object | Sql_commands | Long_query_time | Status |\n+--------+--------+-------+------+----+-------------+--------+--------------+-----------------+--------+\n| ap_all | Y      |       |      |    | TABLE(VIEW) | t1     |              |        0.000000 |        |\n+--------+--------+-------+------+----+-------------+--------+--------------+-----------------+--------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%AE%A1%E8%AE%A1%E7%AD%96%E7%95%A5%E5%8F%82%E6%95%B0%E4%BF%AE%E6%94%B9\"><\/span>\u5ba1\u8ba1\u7b56\u7565\u53c2\u6570\u4fee\u6539<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; alter audit policy ddl_dml_policy set(sql_commands='update,delete,create_table,truncate,drop_table,alter_table');\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\n\ngbase&gt; select * from audit_policy;\nERROR 1146 (42S02): Table 'testdb.audit_policy' doesn't exist\ngbase&gt; select * from gbase.audit_policy;\n+----------------+--------+-------+------+----+----------+--------+------------------------------------------------------------+-----------------+--------+\n| Name           | Enable | Hosts | User | Db | Obj_type | Object | Sql_commands                                               | Long_query_time | Status |\n+----------------+--------+-------+------+----+----------+--------+------------------------------------------------------------+-----------------+--------+\n| ddl_dml_policy | Y      |       |      |    |          |        | DELETE,UPDATE,CREATE_TABLE,ALTER_TABLE,DROP_TABLE,TRUNCATE |        0.000000 |        |\n+----------------+--------+-------+------+----+----------+--------+------------------------------------------------------------+-----------------+--------+\n1 row in set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"893\" height=\"750\" src=\"http:\/\/www.gbase8.cn\/wp-content\/uploads\/2020\/06\/image-53.png\" alt=\"\" class=\"wp-image-169\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%AE%A1%E8%AE%A1%E7%AD%96%E7%95%A5%E5%88%A0%E9%99%A4\"><\/span>\u5ba1\u8ba1\u7b56\u7565\u5220\u9664<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select * from gbase.audit_policy;\n+---------+--------+-------+------+----+----------+--------+--------------+-----------------+--------+\n| Name    | Enable | Hosts | User | Db | Obj_type | Object | Sql_commands | Long_query_time | Status |\n+---------+--------+-------+------+----+----------+--------+--------------+-----------------+--------+\n| p_all   | Y      |       |      |    |          |        |              |        0.000000 |        |\n| p_all_2 | Y      |       |      |    |          |        |              |        0.000000 |        |\n+---------+--------+-------+------+----+----------+--------+--------------+-----------------+--------+\n2 rows in set (Elapsed: 00:00:00.00)\n\ngbase&gt; drop audit policy p_all_2;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\n\ngbase&gt; select * from gbase.audit_policy;\n+-------+--------+-------+------+----+----------+--------+--------------+-----------------+--------+\n| Name  | Enable | Hosts | User | Db | Obj_type | Object | Sql_commands | Long_query_time | Status |\n+-------+--------+-------+------+----+----------+--------+--------------+-----------------+--------+\n| p_all | Y      |       |      |    |          |        |              |        0.000000 |        |\n+-------+--------+-------+------+----+----------+--------+--------------+-----------------+--------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%AE%A1%E8%AE%A1%E6%97%A5%E5%BF%97TABLE%E6%A0%BC%E5%BC%8F%E7%9A%84%E6%A0%B7%E4%BE%8B\"><\/span>\u5ba1\u8ba1\u65e5\u5fd7TABLE\u683c\u5f0f\u7684\u6837\u4f8b<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; select * from gbase.audit_log;\n+-----------+---------+---------------------+---------------------+----------------------------+-----+------+------------+-----------------+------+--------+--------------------------------------------------+-------------------------------------+----------+-------------+-----------+---------+-----------+\n| thread_id | taskid  | start_time          | end_time            | user_host                  | uid | user | host_ip    | query_time      | rows | db     | table_list                                       | sql_text                            | sql_type | sql_command | operators | status  | conn_type |\n+-----------+---------+---------------------+---------------------+----------------------------+-----+------+------------+-----------------+------+--------+--------------------------------------------------+-------------------------------------+----------+-------------+-----------+---------+-----------+\n|         7 |       0 | 2020-11-30 09:27:22 | 2020-11-30 09:27:22 | root&#91;root] @  &#91;10.0.2.201] |   1 | root | 10.0.2.201 | 00:00:00.000036 |    0 | testdb |                                                  | Ping                                | OTHERS   | Ping        |           | SUCCESS | CAPI      |\n|         7 | 3276834 | 2020-11-30 09:27:22 | 2020-11-30 09:27:22 | root&#91;root] @  &#91;10.0.2.201] |   1 | root | 10.0.2.201 | 00:00:00.000197 |    0 | testdb | WRITE: ; READ: ; OTHER: ;                        | SET NAMES utf8mb4                   | OTHERS   | OTHERS      |           | SUCCESS | CAPI      |\n|         7 |       0 | 2020-11-30 09:27:22 | 2020-11-30 09:27:22 | root&#91;root] @  &#91;10.0.2.201] |   1 | root | 10.0.2.201 | 00:00:00.000090 |    0 | testdb | WRITE: ; READ: ; OTHER: ;                        | set  SELF global log_output='table' | OTHERS   | OTHERS      |           | SUCCESS | CAPI      |\n|         5 | 3276833 | 2020-11-30 09:27:22 | 2020-11-30 09:27:22 | root&#91;root] @ localhost &#91;]  |   1 | root |            | 00:00:00.001803 |    0 | testdb | WRITE: ; READ: ; OTHER: ;                        | set global log_output='table'       | OTHERS   | OTHERS      |           | SUCCESS | CAPI      |\n|         5 | 3276835 | 2020-11-30 09:27:27 | 2020-11-30 09:27:27 | root&#91;root] @ localhost &#91;]  |   1 | root |            | 00:00:00.000249 |    2 | testdb | WRITE: ; READ: `gbase`.`audit_policy`; OTHER: ;  | select * from gbase.audit_policy    | DQL      | SELECT      |           | SUCCESS | CAPI      |\n|         5 | 3276836 | 2020-11-30 09:27:40 | 2020-11-30 09:27:40 | root&#91;root] @ localhost &#91;]  |   1 | root |            | 00:00:00.000254 |    2 | testdb | WRITE: ; READ: `gbase`.`audit_policy`; OTHER: ;  | select * from gbase.audit_policy    | DQL      | SELECT      |           | SUCCESS | CAPI      |\n+-----------+---------+---------------------+---------------------+----------------------------+-----+------+------------+-----------------+------+--------+--------------------------------------------------+-------------------------------------+----------+-------------+-----------+---------+-----------+\n6 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%AE%A1%E8%AE%A1%E6%97%A5%E5%BF%97%E6%96%87%E4%BB%B6%E6%A0%BC%E5%BC%8F%E7%9A%84%E6%A0%B7%E4%BE%8B\"><\/span>\u5ba1\u8ba1\u65e5\u5fd7\u6587\u4ef6\u683c\u5f0f\u7684\u6837\u4f8b<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code># Threadid=11;\n# Taskid=3276831;\n# End_time: 201130  9:00:00\n# User@Host: root&#91;root] @ % &#91;%]\n# UID: 10584827\n# Query_time: 0.000137 Rows: 0\n# Tables: WRITE: `gbase`.`audit_log_bak1`; READ: ; OTHER: ; ;\n# SET timestamp=1606698000;\n# Sql_text: drop self table gbase.audit_log_bak1;\n# Sql_type: DDL;\n# Sql_command: DROP_TABLE;\n# Status: SUCCESS;\n# Connect Type: ;\n\n# Threadid=5;\n# Taskid=3276832;\n# Time: 201130  9:00:40\n# End_time: 201130  9:00:40\n# User@Host: root&#91;root] @ localhost &#91;]\n# UID: 1\n# Query_time: 0.001134 Rows: 1\n# use testdb;\n# Tables: WRITE: ; READ: `gbase`.`audit_policy`; OTHER: ; ;\n# SET timestamp=1606698040;\n# Sql_text: select * from gbase.audit_policy where name='audit_all';\n# Sql_type: DQL;\n# Sql_command: SELECT;\n# Algorithms: WHERE;\n# Status: SUCCESS;\n# Connect Type: CAPI;\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%AE%A1%E8%AE%A1%E6%97%A5%E5%BF%97%E5%BD%92%E6%A1%A3\"><\/span>\u5ba1\u8ba1\u65e5\u5fd7\u5f52\u6863<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>862B33\u7248\u672c\u4ee5\u540e\uff0c\u5728\u96c6\u7fa4\u5b89\u88c5\u540e\uff0c\u4f1a\u81ea\u52a8\u5728gclusterdb\u4e0b\u521b\u5efa\u4e00\u4e2aimport_audit_log\u7684event,\u8be5\u5b9a\u65f6\u4efb\u52a1\u81ea\u52a8\u521b\u5efagclusterdb.audit_log_express\u8868\uff0c\u5e76\u5b9a\u65f6\u5c06gbase.audit_log\u7684SQL\u8f6c\u79fb\u5230gclusterdb.audit_log_express\u8868\u91cc\u9762\u3002<\/p>\n\n\n\n<p>\u5177\u4f53\u7684event\u53ef\u4ee5\u901a\u8fc7show create event gclustedb.import_audit_log\u67e5\u770b\u3002<\/p>\n\n\n\n<p>\u6ce8\u610f\uff1aV95\u7248\u672c\u7684\u5ba1\u8ba1\u65e5\u5fd7\u5f52\u6863\u529f\u80fdevent, \u7531\u4e8e\u5f15\u5165\u4e86vc\uff0c\u6240\u4ee5\u9ed8\u8ba4\u662f\u4e0d\u751f\u6548\u7684\uff0c\u7528\u6237\u53ef\u4ee5\u5220\u6389\u73b0\u6709\u7684event\u7136\u540e\u518d\u91cd\u65b0\u521b\u5efa\uff0c\u6216\u8005\u624b\u5de5\u505a\u4fee\u6539\u3002 \u53c2\u8003  <a href=\"https:\/\/www.gbase8.cn\/700?hilite=%E5%AE%A1%E8%AE%A1%E6%97%A5%E5%BF%97\">GBase 8a\u6570\u636e\u5e93\u96c6\u7fa4V95\u7248\u672c\u76f8\u5bf9V8\u7248\u672c\u53d8\u52a8\u5185\u5bb9\u6c47\u603b<\/a> \u5176\u4e2d\u7684\u3010\u91cd\u5927\u53d8\u52a8\u90e8\u5206\u3011\u7684\u3010<a href=\"https:\/\/www.gbase8.cn\/700?hilite=%E5%AE%A1%E8%AE%A1%E6%97%A5%E5%BF%97#%E5%AE%A1%E8%AE%A1%E6%97%A5%E5%BF%97%E5%BD%92%E6%A1%A3%E7%9A%84event%E9%BB%98%E8%AE%A4%E4%B8%8D%E5%8F%AF%E7%94%A8\"><mark>\u5ba1\u8ba1\u65e5\u5fd7<\/mark>\u5f52\u6863\u7684event\u9ed8\u8ba4\u4e0d\u53ef\u7528<\/a>\u3011<\/p>\n\n\n\n<p>\u7531\u4e8eevent\u662f\u8282\u70b9\u7ea7\u522b\u7684\uff0c\u5728\u6bcf\u4e2a\u7ba1\u7406\u8282\u70b9\u90fd\u521b\u5efa\u4e86\u3002\u5982\u679c\u4f60\u66f4\u6539\u8fd9\u4e2aevent,\u8bf7\u5c06\u6bcf\u4e2a\u7ba1\u7406\u8282\u70b9\u90fd\u66f4\u65b0\u4e00\u4e0b\u3002<\/p>\n\n\n\n<p><strong>\u8be5event<\/strong><strong>\u5bf9\u6570\u636e\u8282\u70b9(gnode)<\/strong><strong>\u7684\u5ba1\u8ba1\u65e5\u5fd7\u65e0\u6548<\/strong>\u3002<\/p>\n\n\n\n<p>\u76ee\u524d\u5f52\u6863\u8868\u6ca1\u6709\u8001\u5316\u529f\u80fd\u3002<\/p>\n\n\n\n<p>862Build20\u7684\u5ba1\u8ba1\u65e5\u5fd7<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>set sql_mode='';\ncreate self table  audit_log_1  (\n   thread_id  int(10) unsigned NOT NULL,\n   taskid  bigint(20) NOT NULL,\n   start_time  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n   end_time  timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',\n   user_host  mediumtext NOT NULL,\n   user  mediumtext NOT NULL,\n   host_ip  mediumtext NOT NULL,\n   query_time  time NOT NULL,\n   rows  bigint(20) NOT NULL,\n   db  varchar(512) NOT NULL,\n   table_list  mediumtext NOT NULL,\n   sql_text  mediumtext NOT NULL,\n   sql_type  mediumtext NOT NULL,\n   sql_command  mediumtext NOT NULL,\n   algorithms  mediumtext NOT NULL,\n   status  mediumtext NOT NULL,\n   conn_type  mediumtext NOT NULL\n) ENGINE=GsSYS <\/code><\/pre>\n\n\n\n<p>8.6.2.43-R28\u7684\u4f8b\u5b50\uff0c\u652f\u6301utf8mb4<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>CREATE EVENT \"import_audit_log\" \n    ON SCHEDULE EVERY 60 MINUTE STARTS '2017-12-01 00:00:00' \n\tON COMPLETION NOT PRESERVE \n\tENABLE LOCAL \nDO begin \n    declare errno int;\n    declare msg text;\n    declare exit handler for sqlexception \n    begin \n        get diagnostics condition 1 errno = gbase_errno, msg = message_text; \n        create table if not exists import_audit_log_errors(\n            err_time datetime, \n            hostname varchar(64), \n            err_no int, \n            msg_txt varchar(1024)\n        ) CHARSET=utf8mb4; \n        insert into import_audit_log_errors values (now(), @@hostname, errno, substr(msg, 0, 1024));\n    end; \n    create table if not exists audit_log_express (\n        hostname varchar(64), \n        thread_id int, \n        taskid bigint, \n        start_time datetime, \n        uid bigint, \n        user varchar(16), \n        host_ip varchar(32), \n        query_time time, \n        rows bigint, \n        table_list varchar(4096), \n        sql_text varchar(8191), \n        sql_type varchar(16), \n        sql_command varchar(32), \n        operators varchar(256), \n        status varchar(16), \n        conn_type varchar(16)\n     ) CHARSET=utf8mb4; \n     set self sql_mode = ''; \n     create self table gbase.audit_log_bak2 like gbase.audit_log; \n     set self sql_mode = default; \n     rename self table gbase.audit_log to gbase.audit_log_bak1, gbase.audit_log_bak2 to gbase.audit_log; \n     set _gbase_query_path = on; \n     insert into audit_log_express select \n        @@hostname as hostname, \n        thread_id, \n        taskid, \n        start_time, \n        uid, \n        user, \n        host_ip, \n        query_time, \n        rows, \n        substr(table_list, 0, 4096), \n        substr(sql_text, 0, 8191), \n        sql_type, \n        sql_command, \n        operators, \n        status, \n        conn_type \n    from gbase.audit_log_bak1; \n    drop self table gbase.audit_log_bak1; \nend <\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%99%BB%E5%BD%95%E5%AF%86%E7%A0%81%E9%94%99%E8%AF%AF%E8%AE%B0%E5%BD%95\"><\/span>\u767b\u5f55\u5bc6\u7801\u9519\u8bef\u8bb0\u5f55<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u767b\u5f55\u6570\u636e\u5e93\u5bc6\u7801\u9519\u8bef\u65f6\uff0c\u5ba1\u8ba1\u65e5\u5fd7\u4f1a\u6709\u8bb0\u5f55\u3002<\/p>\n\n\n\n<p>\u5982\u4e0b\u767b\u5f55<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;gbase@862b43 ~]$ gccli -uroot -p1111\nERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)\n<\/code><\/pre>\n\n\n\n<p>\u5ba1\u8ba1\u65e5\u5fd7\uff0c\u767b\u5f55\u7684sql_command\u662fconnect, status\u4e3aFAILED\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select * from gbase.audit_log where sql_command='Connect' \\G;\n*************************** 1. row ***************************\n  thread_id: 21\n     taskid: 0\n start_time: 2021-03-09 15:35:59\n   end_time: 2021-03-09 15:35:59\n  user_host: &#91;root] @ localhost &#91;]\n        uid: 0\n       user: root\n    host_ip:\n query_time: 00:00:00.000124\n       rows: 0\n         db:\n table_list:\n   sql_text: Connect\n   sql_type: OTHERS\nsql_command: Connect\n  operators:\n     status: FAILED\n  conn_type: CAPI\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%89%A7%E8%A1%8C%E8%AF%AD%E6%B3%95%E9%94%99%E8%AF%AF%E7%9A%84SQL\"><\/span>\u6267\u884c\u8bed\u6cd5\u9519\u8bef\u7684SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u5982\u4e0b\u968f\u610f\u5199\u4e86\u4e2a\u5b57\u7b26\u4e32<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;gbase@862b43 ~]$ gccli -uroot -e\"ABCDE\"\nERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your GBase server version for the right syntax to use near 'ABCDE' at line 1\n&#91;gbase@862b43 ~]$ <\/code><\/pre>\n\n\n\n<p>\u5ba1\u8ba1\u65e5\u5fd7\u8bb0\u5f55\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  thread_id: 22\n     taskid: 0\n start_time: 2021-03-09 15:37:41\n   end_time: 2021-03-09 15:37:41\n  user_host: root&#91;root] @ localhost &#91;]\n        uid: 1\n       user: root\n    host_ip:\n query_time: 00:00:00.000046\n       rows: 0\n         db:\n table_list:\n   sql_text: ABCDE\n   sql_type: OTHERS\nsql_command: OTHERS\n  operators:\n     status: FAILED\n  conn_type: CAPI\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u5357\u5927\u901a\u7528GBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\u63d0\u4f9b\u4e86\u5ba1\u8ba1\u65e5\u5fd7audit_log\uff0c\u8bb0\u5f55\u6570\u636e\u5e93\u6267\u884c\u7684\u6240\u6709SQL\u3002\u901a\u8fc7\u53c2\u6570\u6216\u5ba1\u8ba1\u7b56\u7565\uff0c\u4fdd\u7559\u7b26\u5408\u6761\u4ef6\u7684\u65e5\u5fd7\u5230\u6587\u4ef6\u6216\u8868\u91cc\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"aside","meta":{"footnotes":""},"categories":[3,6],"tags":[13,28],"class_list":{"0":"post-168","1":"post","2":"type-post","3":"status-publish","4":"format-aside","5":"hentry","6":"category-gbase8a","8":"tag-13","9":"tag-28","10":"post_format-post-format-aside"},"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/168","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=168"}],"version-history":[{"count":41,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/168\/revisions"}],"predecessor-version":[{"id":11674,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/168\/revisions\/11674"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}