{"id":4841,"date":"2018-03-19T08:41:48","date_gmt":"2018-03-19T15:41:48","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=4841"},"modified":"2025-06-13T17:22:38","modified_gmt":"2025-06-14T00:22:38","slug":"auditing-couchbase-n1ql-statements","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/auditing-couchbase-n1ql-statements\/","title":{"rendered":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 N1QL \uba85\ub839\ubb38 \uac10\uc0ac\ud558\uae30"},"content":{"rendered":"<p><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/announcing-couchbase-server-5-5\/\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc11c\ubc84 5.5<\/a> \uc5d0\ub294 \uc0ac\uc6a9\uc790\uac00 \uc218\ud589\ud55c \ubaa8\ub4e0 N1QL \uc791\uc5c5\uc744 \uae30\ub85d\ud558\ub294 \uae30\ub2a5\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc774\uac83\uc740 Couchbase\uc758 \ubcf4\ub2e4 \uc77c\ubc18\uc801\uc778 <a href=\"https:\/\/docs.couchbase.com\/server\/current\/learn\/security\/auditing.html\" target=\"_blank\" rel=\"noopener noreferrer\">\uac10\uc0ac<\/a> \uae30\ub2a5\uc774 5.0\uc5d0 \ub3c4\uc785\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uac10\uc0ac\ub294 Enterprise \uc5d0\ub514\uc158\uc5d0\uc11c\ub9cc \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uac10\uc0ac\ub97c \ud1b5\ud574 \uc2dc\uc2a4\ud15c \uad00\ub9ac\uc790\ub294 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ub204\uac00 \uc5b4\ub5a4 \ub370\uc774\ud130\uc5d0 \uc561\uc138\uc2a4\ud558\ub294\uc9c0 \ucd94\uc801\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub294 \uc800\uc7a5\ub418\ub294 \ub370\uc774\ud130\uac00 \uc0ac\uc6a9\uc790\uc5d0 \ub300\ud55c \uc815\ubcf4\uc640 \uac19\uc774 \uc5b4\ub5a4 \uc2dd\uc73c\ub85c\ub4e0 \ubbfc\uac10\ud55c \ub370\uc774\ud130\uc77c \ub54c \uc911\uc694\ud569\ub2c8\ub2e4. Couchbase Server 5.5\ub294 N1QL \ubb38 \uac10\uc0ac\ub97c \uc9c0\uc6d0\ud558\uba70, \uad00\ub9ac\uc790\uac00 \uc2e4\uc81c\ub85c \uc5b4\ub5a4 \uc720\ud615\uc758 \ubb38(SELECT? INSERT?)\uc744 \uac10\uc0ac\ud574\uc57c \ud558\ub294\uc9c0 \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>Couchbase Server 5.5\uc5d0\uc11c \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294 \uae30\ub2a5\uc744 \uc774\ud574\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \ud2b9\ud788 \ub808\ucf54\ub4dc \uc218\uc900 \uac10\uc0ac\ub97c \ud5c8\uc6a9\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. UPDATE \ubb38\uc774 \uc2e4\ud589\ub418\uc5b4 5\uac1c\uc758 \ub808\ucf54\ub4dc\ub97c \uc218\uc815\ud558\ub294 \uacbd\uc6b0, \uac10\uc0ac \ub808\ucf54\ub4dc\uc5d0\ub294 \uc804\ub2ec\ub41c \ubaa8\ub4e0 \ub9e4\uac1c \ubcc0\uc218\ub97c \ud3ec\ud568\ud558\uc5ec \uc2e4\ud589\ub41c \uc804\uccb4 \ubb38\uc774 \ud3ec\ud568\ub418\uba70 5\uac1c\uc758 \ub808\ucf54\ub4dc\uac00 \uc5c5\ub370\uc774\ud2b8\ub418\uc5c8\ub2e4\uace0 \ud45c\uc2dc\ub429\ub2c8\ub2e4. \uc5b4\ub5a4 \ud2b9\uc815 \ub808\ucf54\ub4dc\uac00 \uc5c5\ub370\uc774\ud2b8\ub418\uc5c8\ub294\uc9c0 \ub610\ub294 \uc791\uc5c5 \uc804\uacfc \ud6c4\uc758 \uac12\uc740 \uc54c\ub824\uc8fc\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c N1QL \uac10\uc0ac\ub294 \ub808\ucf54\ub4dc\uac00 \uc544\ub2cc \ubb38\uc744 \uac10\uc0ac\ud569\ub2c8\ub2e4.<\/p>\n<p>\uac10\uc0ac\ub97c \uad6c\uc131\ud558\ub824\uba74 Couchbase \uad00\ub9ac\uc790 \ucf58\uc194\uc5d0 \ub85c\uadf8\uc778\ud569\ub2c8\ub2e4. \ubcf4\uc548 \ud0ed(\uce21\uba74)\uacfc \uac10\uc0ac \ud0ed(\ud654\uba74 \uc0c1\ub2e8\uc5d0 \uc788\uc74c)\uc73c\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4. \uc774\uc81c \ub2e4\uc74c\uacfc \uac19\uc740 \ud654\uba74\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-4843\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/03\/audit-config-original-1024x616.png\" alt=\"\" width=\"900\" height=\"541\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/audit-config-original-1024x616.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/audit-config-original-300x181.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/audit-config-original-768x462.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/audit-config-original-1536x925.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/audit-config-original-2048x1233.png 2048w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/audit-config-original-20x12.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/audit-config-original-1320x795.png 1320w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<p>\uc774 \ud0ed\uc5d0\uc11c\ub294 \uc77c\ubc18\uc801\uc778 \uac10\uc0ac\ub97c \uad6c\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc0c1\ub2e8\uc758 \ud655\uc778\ub780\uc740 \uac10\uc0ac\ub97c \uc218\ud589\ud560\uc9c0 \uc5ec\ubd80\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \"\ub300\uc0c1 \ub85c\uadf8 \ub514\ub809\ud130\ub9ac\"\uc5d0\ub294 \uac10\uc0ac \ub85c\uadf8 \ub808\ucf54\ub4dc\ub97c \uc800\uc7a5\ud560 \uc704\uce58\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4. \ub808\ucf54\ub4dc\ub294 \ub300\uc0c1 \ub85c\uadf8 \ub514\ub809\ud130\ub9ac\uc758 \"audit.log\"\ub77c\ub294 \ud30c\uc77c\uc5d0 \ub098\ud0c0\ub0a9\ub2c8\ub2e4. \ub2e4\uc74c \ud14d\uc2a4\ud2b8 \uc0c1\uc790 \uc138\ud2b8\ub294 \ud06c\uae30\uc640 \uc2dc\uac04 \uac04\uaca9\uc5d0 \ub530\ub77c \ub85c\uadf8 \uc21c\ud658\uc744 \uc81c\uc5b4\ud569\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\uc74c\uc740 \ub2e4\uc591\ud55c \uc720\ud615\uc758 \uc774\ubca4\ud2b8\uc5d0 \ub300\ud55c \uc138 \uac00\uc9c0 \ub4dc\ub86d\ub2e4\uc6b4\uc73c\ub85c, \uc5b4\ub5a4 \uc885\ub958\uc758 \ud65c\ub3d9\uc744 \uae30\ub85d\ud560\uc9c0 \uc138\ubc00\ud558\uac8c \uc81c\uc5b4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \uaf2d \ud544\uc694\ud55c \uac83\ub9cc \uac10\uc0ac\ud558\uc138\uc694. \uac10\uc0ac\uc758 \uc2e4\uc81c \ucc98\ub9ac\ub7c9 \ube44\uc6a9\uc740 \uac10\uc0ac \ub300\uc0c1\uacfc \uac10\uc0ac \ub300\uc0c1 \uba85\uc138\uc11c\uc758 \uc720\ud615\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9d1\ub2c8\ub2e4. \uac10\uc0ac\ub85c \uc778\ud55c \ucc98\ub9ac\ub7c9 \uc190\uc2e4 10%\ub294 \ud569\ub9ac\uc801\uc778 \uc989\uc11d \ucd94\uc815\uce58\uc774\uc9c0\ub9cc, \uc0c8 \uc2dc\uc2a4\ud15c\uc744 \ubc30\ud3ec\ud558\uae30 \uc804\uc5d0 \ubc18\ub4dc\uc2dc \uc2e4\uc81c \ud6a8\uacfc\ub97c \ud14c\uc2a4\ud2b8\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p>\ub9c8\uc9c0\ub9c9\uc73c\ub85c '\uc774 \uc0ac\uc6a9\uc790\uc758 \uc774\ubca4\ud2b8 \ubb34\uc2dc' \uc0c1\uc790\uc5d0\uc11c \uc0ac\uc6a9\uc790\ub97c \ud654\uc774\ud2b8\ub9ac\uc2a4\ud2b8\uc5d0 \ucd94\uac00\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc0ac\uc6a9\uc790\ub294 \uc644\uc804\ud788 \uc2e0\ub8b0\ud560 \uc218 \uc788\ub294 \uc0ac\uc6a9\uc790\uc774\ubbc0\ub85c \uc791\uc5c5\uc744 \uae30\ub85d\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \uc0c8 \ub370\uc774\ud130\ub97c \uc0bd\uc785\ud558\ub294 \uc790\ub3d9\ud654\ub41c \uc2a4\ud06c\ub9bd\ud2b8\uac00 \uc788\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc804\uc801\uc73c\ub85c \uc2e0\ub8b0\ud569\ub2c8\ub2e4. \ud654\uc774\ud2b8\ub9ac\uc2a4\ud2b8 \uc0ac\uc6a9\uc790\ub97c \ub9cc\ub4e4\uace0 \uc2a4\ud06c\ub9bd\ud2b8\uc5d0\uc11c \ud574\ub2f9 \uc0ac\uc6a9\uc790\uc758 \uc790\uaca9 \uc99d\uba85\uc744 \uc0ac\uc6a9\ud558\ub3c4\ub85d \ud558\uba74 \uac10\uc0ac \ub808\ucf54\ub4dc\uac00 \ub108\ubb34 \ub9ce\uc774 \uc0dd\uc131\ub418\ub294 \uac83\uc744 \ubc29\uc9c0\ud558\ub294 \ub370 \uc720\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>'N1QL \uc774\ubca4\ud2b8' \ub4dc\ub86d\ub2e4\uc6b4\uc744 \ud1a0\uae00\ud558\uc5ec N1QL\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc774\ubca4\ud2b8 \uc720\ud615\uc744 \ud655\uc778\ud569\ub2c8\ub2e4.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-4844\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/03\/audit-dropdown-screenshot-1024x555.png\" alt=\"\" width=\"900\" height=\"488\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/audit-dropdown-screenshot-1024x555.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/audit-dropdown-screenshot-300x163.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/audit-dropdown-screenshot-768x416.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/audit-dropdown-screenshot-1536x833.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/audit-dropdown-screenshot-20x11.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/audit-dropdown-screenshot-1320x715.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/audit-dropdown-screenshot.png 2048w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<p>\ub450 \uac00\uc9c0 \uc77c\ubc18\uc801\uc778 \uc720\ud615\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uccab \ubc88\uc9f8\ub294 N1QL \ubb38 \uc720\ud615\uc5d0 \ud574\ub2f9\ud558\ub294 \uc774\ubca4\ud2b8\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ubaa8\ub4e0 INSERT \uc774\ubca4\ud2b8 \ub610\ub294 \ubaa8\ub4e0 DELETE \uc774\ubca4\ud2b8\ub97c \uac10\uc0ac\ud558\ub3c4\ub85d \uc120\ud0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub370\uc774\ud130\ub97c \uc218\uc815\ud558\ub294 \ubaa8\ub4e0 \uc774\ubca4\ud2b8(INSERT\/DELETE\/UPDATE\/UPSERT)\ub294 \uac10\uc0ac\ud558\uc9c0\ub9cc \ub370\uc774\ud130\ub9cc \uac80\uc0c9\ud558\ub294 \ubb38(SELECT)\uc740 \ubb34\uc2dc\ud558\ub294 \uac83\uc774 \ud569\ub9ac\uc801\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub450 \ubc88\uc9f8\ub294 \ucffc\ub9ac \uc5d4\uc9c4\uc5d0 \uc758\ud574 \ub178\ucd9c\ub41c API\uc5d0 \ud574\ub2f9\ud558\ub294 \uc774\ubca4\ud2b8\uc785\ub2c8\ub2e4. N1QL \ucffc\ub9ac \uc5d4\uc9c4\uc740 \uc77c\ubc18\uc801\uc73c\ub85c \uc2dc\uc2a4\ud15c \ubaa8\ub2c8\ud130\ub9c1\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc5ec\ub7ec API\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uac01 API \uc5d4\ub4dc\ud3ec\uc778\ud2b8\ub294 \ubcc4\ub3c4\uc758 \uc774\ubca4\ud2b8 \uc720\ud615\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \/admin\/stats \uc5d4\ub4dc\ud3ec\uc778\ud2b8\uc640 \/admin\/ping \uc5d4\ub4dc\ud3ec\uc778\ud2b8\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c API\uc5d0 \ub300\ud55c \uc561\uc138\uc2a4\ub97c \uac10\uc0ac\ud560\uc9c0 \uc5ec\ubd80\ub294 \ubcc4\ub3c4\ub85c \uc81c\uc5b4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h4>\uc77c\ubc18 \ucffc\ub9ac<\/h4>\n<p>\uac04\ub2e8\ud55c SELECT \ubb38\uc744 \uac10\uc0ac\ud558\ub294 \uac83\uc73c\ub85c \uc2dc\uc791\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uad00\ub9ac\uc790 \ucf58\uc194\uc758 \"\ubc84\ud0b7\" \ud398\uc774\uc9c0\ub85c \uc774\ub3d9\ud558\uc5ec \"test\"(\ub530\uc634\ud45c \uc81c\uc678)\ub77c\ub294 \uc774\ub984\uc758 \ubc84\ud0b7\uc744 \ub9cc\ub4ed\ub2c8\ub2e4. \uba54\ubaa8\ub9ac \ud560\ub2f9\ub7c9\uc740 100MB\uba74 \ucda9\ubd84\ud569\ub2c8\ub2e4. \uadf8\ub7f0 \ub2e4\uc74c \ucffc\ub9ac\ub85c \uc774\ub3d9\ud558\uc5ec \uc0c8 \ubc84\ud0b7\uc5d0 \uae30\ubcf8 \uc778\ub371\uc2a4\ub97c \ub9cc\ub4e4\uc5b4 N1QL \ucffc\ub9ac\ub97c \uc2e4\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4.<\/p>\n<p><code>\ud14c\uc2a4\ud2b8\uc5d0 \uae30\ubcf8 \uc778\ub371\uc2a4 \uc0dd\uc131<\/code><\/p>\n<p>\uac10\uc0ac \uad6c\uc131 \ud654\uba74\uc73c\ub85c \ub3cc\uc544\uac00\uc11c \uc0c1\ub2e8\uc758 \"\uc774\ubca4\ud2b8 \uac10\uc0ac \ubc0f \ub85c\uadf8\uc5d0 \uc4f0\uae30\"\ub97c \uc120\ud0dd\ud558\uace0 \"N1QL \uc774\ubca4\ud2b8\" \uc544\ub798\uc758 \"SELECT \ubb38\" \uc635\uc158\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4. \uadf8\ub7f0 \ub2e4\uc74c \ud654\uba74 \ud558\ub2e8\uc758 \"\uc800\uc7a5\"\uc744 \ub204\ub985\ub2c8\ub2e4.<\/p>\n<p>\uadf8\ub7f0 \ub2e4\uc74c \ub2e4\uc74c\uacfc \uac19\uc774 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/p>\n<p><code>curl https:\/\/localhost:8093\/query\/service -d \"statement=select * from test\" -u \uad00\ub9ac\uc790:\ube44\ubc00\ubc88\ud638<\/code><\/p>\n<p>\uc774\uc81c \uac10\uc0ac \ub85c\uadf8\ub97c \uc0b4\ud3b4\ubd05\uc2dc\ub2e4. \uac10\uc0ac \uad6c\uc131 \ud654\uba74\uc758 '\ub300\uc0c1 \ub85c\uadf8 \ub514\ub809\ud130\ub9ac' \ud544\ub4dc\uc5d0\ub294 \uac10\uc0ac \ub85c\uadf8\uac00 \uc800\uc7a5\ub41c \ub514\ub809\ud130\ub9ac\uac00 \uc788\uc2b5\ub2c8\ub2e4. \"tail\" \uba85\ub839\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc774 \ub514\ub809\ud130\ub9ac\uc5d0 \uc788\ub294 \uac10\uc0ac \ub85c\uadf8\uc758 \ub9c8\uc9c0\ub9c9 \uba87 \uac1c\uc758 \ub808\ucf54\ub4dc\ub97c \ud45c\uc2dc\ud558\uaca0\uc2b5\ub2c8\ub2e4. Mac \uc2dc\uc2a4\ud15c\uc5d0\uc11c\ub294 \uc774 \uba85\ub839\uc774 \uc791\ub3d9\ud569\ub2c8\ub2e4:<\/p>\n<p><code>\uaf2c\ub9ac ~\/\ub77c\uc774\ube0c\ub7ec\ub9ac\/\uc560\ud50c\ub9ac\ucf00\uc774\uc158\\ \uc9c0\uc6d0\/\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\/var\/lib\/\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\/\ub85c\uadf8\/\uac10\uc0ac.\ub85c\uadf8<\/code><\/p>\n<p>\uc5ec\ub7ec \uc904\uc758 \uae34 JSON \ud14d\uc2a4\ud2b8\uac00 \ud45c\uc2dc\ub420 \uac83\uc785\ub2c8\ub2e4. \uac01 \uc904\uc740 \ud558\ub098\uc758 \uac10\uc0ac \ub808\ucf54\ub4dc\uc785\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9 \uc904\uc740 \uc800\ud76c\uac00 \ubcf4\ub0b8 \uba85\uc138\uc11c\uc5d0 \ub300\ud55c \ub808\ucf54\ub4dc\uc785\ub2c8\ub2e4. \uc11c\uc2dd\uc744 \ub2e4\uc2dc \uc9c0\uc815\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \ubcf4\uc785\ub2c8\ub2e4:<\/p>\n<pre>{\r\n  \"timestamp\": \"2018-03-14T05:53:34.976-07:00\",\r\n  \"real_userid\": {\r\n    \"source\": \"local\",\r\n    \"user\": \"Administrator\"\r\n  },\r\n  \"requestId\": \"d0554df3-fd99-40f5-b911-b3e4f0faf050\",\r\n  \"statement\": \"select * from test\",\r\n  \"isAdHoc\": true,\r\n  \"userAgent\": \"curl\\\/7.43.0\",\r\n  \"node\": \"127.0.0.1:8091\",\r\n  \"status\": \"success\",\r\n  \"metrics\": {\r\n    \"elapsedTime\": \"822.147\\u00b5s\",\r\n    \"executionTime\": \"785.755\\u00b5s\",\r\n    \"resultCount\": 0,\r\n    \"resultSize\": 0\r\n  },\r\n  \"id\": 28672,\r\n  \"name\": \"SELECT statement\",\r\n  \"description\": \"A N1QL SELECT statement was executed\"\r\n}\r\n<\/pre>\n<p>\ubd84\uc57c\ubcc4\ub85c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/p>\n<ul>\n<li>\"\ud0c0\uc784\uc2a4\ud0ec\ud504\"\ub294 \ucffc\ub9ac \ub178\ub4dc\uc758 \uc2dc\uac04\uc744 \ud45c\uc2dc\ud569\ub2c8\ub2e4.<\/li>\n<li>\"real_userid\"\ub294 \uc694\uccad\uacfc \ud568\uaed8 \uc81c\uacf5\ub41c \uc0ac\uc6a9\uc790 \uc790\uaca9 \uc99d\uba85\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 \uae30\ubcf8 \uc81c\uacf5 \uc0ac\uc6a9\uc790\uc778 \"\uad00\ub9ac\uc790\"\uc785\ub2c8\ub2e4.<\/li>\n<li>\"requestId\"\ub294 \ucffc\ub9ac \uc5d4\uc9c4\uc774 \ubaa8\ub4e0 \uc694\uccad\uc5d0 \ub300\ud574 \uc0dd\uc131\ud558\ub294 UUID\uc785\ub2c8\ub2e4. \uc774 ID\ub294 \ub9e4\uc6b0 \ub192\uc740 \ud655\ub960\ub85c \uace0\uc720\ud569\ub2c8\ub2e4.<\/li>\n<li>\"\ubb38\"\uc740 \uc2e4\uc81c \uc2e4\ud589\ud55c \ubb38\uc785\ub2c8\ub2e4.<\/li>\n<li>\uc774 \uacbd\uc6b0 \"isAdHoc\"\uc740 \ucc38\uc774\uba70, \uc900\ube44\ub41c \ubb38\uc744 \uc2e4\ud589\ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub77c \uc2e4\uc81c \uc2e4\ud589\uc744 \uc704\ud574 \ubb38\uc744 \ubcf4\ub0c8\uc74c\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4.<\/li>\n<li>\"userAgent\"\ub294 \uc6d0\ub798 \uc694\uccad\uc758 \uc0ac\uc6a9\uc790 \uc5d0\uc774\uc804\ud2b8 \ubb38\uc790\uc5f4\uc785\ub2c8\ub2e4. \uc774\ub294 \uc694\uccad\uc774 SDK\uc5d0\uc11c \uc654\ub294\uc9c0, CBQ \uc178\uc5d0\uc11c \uc654\ub294\uc9c0, \ucffc\ub9ac \uc6cc\ud06c\ubca4\uce58\uc5d0\uc11c \uc654\ub294\uc9c0 \uad6c\ubd84\ud558\ub294 \ub370 \uc720\uc6a9\ud569\ub2c8\ub2e4.<\/li>\n<li>\"\ub178\ub4dc\"\ub294 \uc694\uccad\uc774 \uc218\uc2e0\ub41c IP \uc8fc\uc18c\uc785\ub2c8\ub2e4.<\/li>\n<li>\"\uc0c1\ud0dc\"\ub294 \uc694\uccad\uc5d0 \uc5b4\ub5a4 \uc77c\uc774 \uc77c\uc5b4\ub0ac\ub294\uc9c0 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \uc774 \uacbd\uc6b0\uc5d0\ub294 \uc131\uacf5\ud588\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\"\uba54\ud2b8\ub9ad\"\uc740 \uacb0\uacfc\uc5d0 \ub300\ud55c \ud1b5\uacc4 \uc9d1\ud569\uc785\ub2c8\ub2e4. \uc774\ub294 \uc6d0\ub798 \uc694\uccad\uc758 \uacb0\uacfc\uc640 \ud568\uaed8 \uc804\uc1a1\ub41c \uba54\ud2b8\ub9ad\uacfc \uc77c\uce58\ud569\ub2c8\ub2e4.<\/li>\n<li>\"id\"\ub294 \uc774\ubca4\ud2b8 \uc720\ud615 ID\uc785\ub2c8\ub2e4. \ubaa8\ub4e0 SELECT \ucffc\ub9ac\uc5d0 \ub300\ud55c \uac10\uc0ac \ub808\ucf54\ub4dc\uc758 ID\ub294 28672\ub85c \ub3d9\uc77c\ud569\ub2c8\ub2e4.<\/li>\n<li>\"name\"\uc740 \uc774\ubca4\ud2b8 \uc720\ud615\uc758 \uc9e7\uc740 \uc774\ub984\uc785\ub2c8\ub2e4. \uc774\ub294 \ubaa8\ub4e0 SELECT \ucffc\ub9ac\uc5d0\uc11c \ub3d9\uc77c\ud558\uac8c \uc801\uc6a9\ub429\ub2c8\ub2e4.<\/li>\n<li>\"description\"\uc740 \uc774\ubca4\ud2b8 \uc720\ud615\uc758 \uae34 \uc774\ub984\uc785\ub2c8\ub2e4. \uc774\ub294 \ubaa8\ub4e0 SELECT \ucffc\ub9ac\uc5d0\uc11c\ub3c4 \ub3d9\uc77c\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>\ucffc\ub9ac \uc5d4\uc9c4\uc740 \uc694\uccad\ub2f9 \uc5ec\ub7ec \uac1c\uc758 \uc790\uaca9 \uc99d\uba85\uc744 \ud5c8\uc6a9\ud558\uc9c0\ub9cc \uac10\uc0ac \uae30\ub85d\uc740 \ud55c \uba85\uc758 \uc0ac\uc6a9\uc790\ub9cc \uc81c\uacf5\ud55c\ub2e4\ub294 \uc810\uc5d0 \uc720\uc758\ud558\uc138\uc694. \uc774\ub294 \uc758\ub3c4\ub41c \uac83\uc785\ub2c8\ub2e4. \uc790\uaca9 \uc99d\uba85\uc774 \ubc84\ud0b7 \ub2e8\uc704\uc600\ub358 \uc2dc\uc808\uc5d0\ub294 N1QL\uc5d0\uc11c \ucffc\ub9ac\uc5d0 \ub300\ud574 \uc5ec\ub7ec \uc790\uaca9 \uc99d\uba85\uc744 \ud5c8\uc6a9\ud588\uae30 \ub54c\ubb38\uc5d0 \ub2e4\uc911 \ubc84\ud0b7 \uc870\uc778\uc744 \uc704\ud574\uc11c\ub294 \uc5ec\ub7ec \uc790\uaca9 \uc99d\uba85\uc774 \ud544\uc694\ud588\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc 5.0 \ubc84\uc804\ubd80\ud130 RBAC\uc5d0\uc11c\ub294 \ub354 \uc774\uc0c1 \uc5ec\ub7ec \uac1c\uc758 \uc790\uaca9 \uc99d\uba85\uc774 \ud544\uc694\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc774\uc804 \ubc84\uc804\uacfc\uc758 \ud638\ud658\uc131\uc744 \uc704\ud574 \uc9c0\uc6d0\ud558\uc9c0\ub9cc, \uc774\ub7ec\ud55c \uacbd\uc6b0\ub97c \ucc98\ub9ac\ud558\ub294 \uc62c\ubc14\ub978 \ubc29\ubc95\uc740 \uc5ec\ub7ec \ubc84\ud0b7\uc5d0 \ub300\ud55c \uc790\uaca9 \uc99d\uba85\uc744 \uac00\uc9c4 \uc0ac\uc6a9\uc790\ub97c \ub9cc\ub4e4\uace0 \uac01 \ucffc\ub9ac\uc5d0 \ub300\ud574 \uadf8\ub7ec\ud55c \uc0ac\uc6a9\uc790 \ud55c \uba85\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uac10\uc0ac\ub41c \ucffc\ub9ac\uc5d0 \uc5ec\ub7ec \uc790\uaca9 \uc99d\uba85\uc744 \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4\uace0 \uace0\uc9d1\ud558\ub294 \uacbd\uc6b0 \ucffc\ub9ac\ub294 \uac10\uc0ac\ub418\uc9c0\ub9cc \uc81c\uacf5\ub41c \ubaa8\ub4e0 \uc790\uaca9 \uc99d\uba85\uc5d0 \ub300\ud574 \ubcc4\ub3c4\uc758 \uac10\uc0ac \uae30\ub85d\uc774 \ub0a8\uac8c \ub429\ub2c8\ub2e4. \uc774\ub294 \ub2e4\uc18c \ubd88\ud3b8\ud558\ubbc0\ub85c \uc774\ub7ec\ud55c \uacbd\uc6b0 RBAC \uad8c\ud55c\uc744 \uc0ac\uc6a9\ud558\ub3c4\ub85d \uad8c\ud55c \ubaa8\ub378\uc744 \uc5c5\ub370\uc774\ud2b8\ud560 \uac83\uc744 \uac15\ub825\ud788 \uad8c\uc7a5\ud569\ub2c8\ub2e4.<\/p>\n<h4>\uba85\uc138\uc11c \uc900\ube44<\/h4>\n<p>\uc774\uc81c \uc900\ube44\ub41c \ubb38\uc774 \uc788\ub294 \uc880 \ub354 \uc815\uad50\ud55c \uacbd\uc6b0\ub97c \uace0\ub824\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uba3c\uc800 \uac10\uc0ac \uad6c\uc131 \ud654\uba74\uc73c\ub85c \ub3cc\uc544\uac00\uc11c SELECT \ubc0f PREPARE \ubb38 \uac10\uc0ac\ub97c \ucf2d\ub2c8\ub2e4. \ud654\uba74 \ud558\ub2e8\uc758 '\uc800\uc7a5'\uc744 \ub204\ub974\ub294 \uac83\uc744 \uc78a\uc9c0 \ub9c8\uc138\uc694.<\/p>\n<p>\uc774\uc81c \uba3c\uc800 \ubb38\uc744 \uc900\ube44\ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc11c\ub294 \uc774\ub984\uc774 \"example\"\uc778 SELECT \ubb38\uc744 \uc900\ube44\ud569\ub2c8\ub2e4. \uc774 \ubb38\uc5d0\ub294 \uc774\ub984 \uc5c6\ub294 \ub9e4\uac1c\ubcc0\uc218\uac00 \uc788\ub2e4\ub294 \uc810\uc5d0 \uc720\uc758\ud558\uc138\uc694.<\/p>\n<p><code>curl https:\/\/localhost:8093\/query\/service -d \"statement=prepare example as select * from test where one=?\" -u \uad00\ub9ac\uc790:\ube44\ubc00\ubc88\ud638<\/code><\/p>\n<p>\uadf8\ub7f0 \ub2e4\uc74c \ubb38\uc5d0 \uc778\uc218\ub97c \uc81c\uacf5\ud558\uc5ec \ubb38\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 \ubb38\uc740 \uc2e4\ud589\ub418\uc9c0\ub9cc \uacb0\uacfc\ub294 \ubc18\ud658\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n<p><code>curl https:\/\/localhost:8093\/query\/service -d 'prepared=\"example\"&amp;args=[\"bar\"]'<\/code><\/p>\n<p>\uc774\uc81c \uac10\uc0ac \ub85c\uadf8\ub97c \ub2e4\uc2dc \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p><code>\uaf2c\ub9ac ~\/\ub77c\uc774\ube0c\ub7ec\ub9ac\/\uc560\ud50c\ub9ac\ucf00\uc774\uc158\\ \uc9c0\uc6d0\/\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\/var\/lib\/\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\/\ub85c\uadf8\/\uac10\uc0ac.\ub85c\uadf8<\/code><\/p>\n<p>\ub85c\uadf8\uc5d0\ub294 \ub450 \uac1c\uc758 \uc774\ubca4\ud2b8\uac00 \ud45c\uc2dc\ub418\ub294\ub370, \ud558\ub098\ub294 PREPARE\uc5d0 \ub300\ud55c \uc774\ubca4\ud2b8\uc774\uace0 \ub2e4\ub978 \ud558\ub098\ub294 \uc900\ube44\ub41c \ubb38\uc5d0\uc11c \uc2e4\ud589\ub41c SELECT\uc5d0 \ub300\ud55c \uc774\ubca4\ud2b8\uc785\ub2c8\ub2e4:<\/p>\n<pre>{\r\n  \"timestamp\": \"2018-03-14T06:27:39.884-07:00\",\r\n  \"real_userid\": {\r\n    \"source\": \"local\",\r\n    \"user\": \"Administrator\"\r\n  },\r\n  \"requestId\": \"9f76b8c2-ed9f-42f8-bc5c-31fb3326a661\",\r\n  \"statement\": \"prepare example as select * from test where one=?\",\r\n  \"isAdHoc\": true,\r\n  \"userAgent\": \"curl\\\/7.43.0\",\r\n  \"node\": \"127.0.0.1:8091\",\r\n  \"status\": \"success\",\r\n  \"metrics\": {\r\n    \"elapsedTime\": \"6.591126ms\",\r\n    \"executionTime\": \"6.515079ms\",\r\n    \"resultCount\": 1,\r\n    \"resultSize\": 1279\r\n  },\r\n  \"id\": 28674,\r\n  \"name\": \"PREPARE statement\",\r\n  \"description\": \"A N1QL PREPARE statement was executed\"\r\n}\r\n{\r\n  \"timestamp\": \"2018-03-14T06:27:52.992-07:00\",\r\n  \"real_userid\": {\r\n    \"source\": \"internal\",\r\n    \"user\": \"unknown\"\r\n  },\r\n  \"requestId\": \"56c5278b-5842-45a9-8549-5c7f52f109a7\",\r\n  \"statement\": \"\",\r\n  \"positionalArgs\": [\r\n    \"\\\"bar\\\"\"\r\n  ],\r\n  \"isAdHoc\": false,\r\n  \"userAgent\": \"curl\\\/7.43.0\",\r\n  \"node\": \"127.0.0.1:8091\",\r\n  \"status\": \"success\",\r\n  \"metrics\": {\r\n    \"elapsedTime\": \"1.363373ms\",\r\n    \"executionTime\": \"1.334763ms\",\r\n    \"resultCount\": 0,\r\n    \"resultSize\": 0\r\n  },\r\n  \"id\": 28672,\r\n  \"name\": \"SELECT statement\",\r\n  \"description\": \"A N1QL SELECT statement was executed\"\r\n}\r\n<\/pre>\n<p>\uac10\uc0ac \ub808\ucf54\ub4dc\uc758 \ud544\ub4dc\ub294 \uc55e\uc11c \uc2e4\ud589\ud55c SELECT \ubb38\uacfc \uc720\uc0ac\ud558\uc9c0\ub9cc \ub450 \uac1c\uc758 \ud544\ub4dc\uac00 \uc8fc\ubaa9\ud560 \ub9cc\ud569\ub2c8\ub2e4:<\/p>\n<ul>\n<li>\"positionalArgs\"\uc5d0\ub294 \ucffc\ub9ac\uc640 \ud568\uaed8 \uc81c\uacf5\ub41c \uc778\uc218\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/li>\n<li>\uc774 \uacbd\uc6b0 SELECT\uac00 \uc774\uc804\uc5d0 \uc804\uc1a1\ub41c \uc900\ube44\ub41c \ubb38\uc5d0\uc11c \uc2e4\ud589\ub418\uc5c8\uc73c\ubbc0\ub85c \"isAdHoc\"\uc740 \uac70\uc9d3\uc785\ub2c8\ub2e4.<\/li>\n<\/ul>\n<h4>API \uc694\uccad<\/h4>\n<p>\ub2e4\uc74c\uc73c\ub85c \ucffc\ub9ac \uc5d4\uc9c4 API \uc911 \ud558\ub098\ub97c \uac10\uc0ac\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uac10\uc0ac \uad6c\uc131 \ud398\uc774\uc9c0\ub85c \uc774\ub3d9\ud558\uc5ec \"\/admin\/ping API \uc694\uccad\" \uc774\ubca4\ud2b8 \uc720\ud615\uc744 \ucf2d\ub2c8\ub2e4. \ud398\uc774\uc9c0 \ud558\ub2e8\uc5d0 \uad6c\uc131\uc744 \uc800\uc7a5\ud558\ub294 \uac83\uc744 \uc78a\uc9c0 \ub9c8\uc138\uc694.<\/p>\n<p>\uc774\uc81c \ud551\uc744 \ubcf4\ub0b4\uc138\uc694:<\/p>\n<p><code>curl -v https:\/\/localhost:8093\/admin\/ping<\/code><\/p>\n<p>\ud558\ub2e8\uc758 '{}'\uac00 \uc804\uccb4 \uacb0\uacfc\uc774\ubbc0\ub85c \ub9ce\uc740 \uac83\uc744 \uae30\ub300\ud558\uc9c0 \ub9c8\uc138\uc694:<\/p>\n<pre>*   Trying ::1...\r\n* Connected to localhost (::1) port 8093 (#0)\r\n&gt; GET \/admin\/ping HTTP\/1.1\r\n&gt; Host: localhost:8093\r\n&gt; User-Agent: curl\/7.43.0\r\n&gt; Accept: *\/*\r\n&gt; \r\n&lt; HTTP\/1.1 200 OK\r\n&lt; Date: Wed, 14 Mar 2018 13:54:24 GMT\r\n&lt; Content-Length: 2\r\n&lt; Content-Type: text\/plain; charset=utf-8\r\n&lt; \r\n* Connection #0 to host localhost left intact\r\n{}\r\n<\/pre>\n<p>\uadf8\ub7f0 \ub2e4\uc74c \uac10\uc0ac \ub85c\uadf8\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4(\ub2e4\uc2dc Mac\uc758 \uc704\uce58\ub97c \uc0ac\uc6a9):<\/p>\n<p><code>\uaf2c\ub9ac ~\/\ub77c\uc774\ube0c\ub7ec\ub9ac\/\uc560\ud50c\ub9ac\ucf00\uc774\uc158\\ \uc9c0\uc6d0\/\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\/var\/lib\/\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\/\ub85c\uadf8\/\uac10\uc0ac.\ub85c\uadf8<\/code><\/p>\n<p>\ud615\uc2dd\uc774 \uc9c0\uc815\ub41c \uacb0\uacfc \uac10\uc0ac \ub85c\uadf8 \uba54\uc2dc\uc9c0\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n<pre>{\r\n  \"timestamp\": \"2018-03-14T06:54:24.887-07:00\",\r\n  \"real_userid\": {\r\n    \"source\": \"internal\",\r\n    \"user\": \"unknown\"\r\n  },\r\n  \"httpMethod\": \"GET\",\r\n  \"httpResultCode\": 200,\r\n  \"errorMessage\": \"\",\r\n  \"id\": 28697,\r\n  \"name\": \"\/admin\/ping API request\",\r\n  \"description\": \"An HTTP request was made to the API at \/admin\/ping.\"\r\n}\r\n<\/pre>\n<p>\uc5ec\uae30\uc11c \"timestamp\" \ubc0f \"real_userid\" \ud544\ub4dc\ub294 SELECT \uc608\uc81c\uc5d0\uc11c\uc640 \uac19\uc774 \uc791\ub3d9\ud569\ub2c8\ub2e4. \"httpMethod\"\ub294 HTTP \uc694\uccad \uc720\ud615\uc785\ub2c8\ub2e4. \"httpResultCode\" \ubc0f \"errorMessage\"\ub294 \uc694\uccad\uc5d0 \uc5b4\ub5a4 \uc77c\uc774 \ubc1c\uc0dd\ud588\ub294\uc9c0 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \"\uc544\uc774\ub514\", \"\uc774\ub984\", \"\uc124\uba85\"\uc740 \uac10\uc0ac \uc774\ubca4\ud2b8\uc5d0 \uace0\uc720\ud558\uba70, \uc774\ub7ec\ud55c \ud544\ub4dc\ub294 \/admin\/ping \uc774\ubca4\ud2b8\uc5d0 \ub300\ud574 \ub9cc\ub4e4\uc5b4\uc9c4 \ubaa8\ub4e0 \uac10\uc0ac \ub808\ucf54\ub4dc\uc5d0 \ub300\ud574 \ub3d9\uc77c\ud558\uac8c \uc801\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n<h4>\ud3ec\uc6cc\ub4dc \ud544\ud130\ub9c1<\/h4>\n<p>(\uc774\uac83\uc740 \uace0\uae09 \uc8fc\uc81c\uc785\ub2c8\ub2e4. \uc774 \uc139\uc158\uc758 \uc790\ub8cc\ub97c \ubab0\ub77c\ub3c4 N1QL \uac10\uc0ac\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uace0\uae09 \uc0ac\uc6a9\uc790\ub77c\uba74 \ub0b4\ubd80\ub97c \uc0b4\ud3b4\ubcf4\ub294 \uac83\uc774 \ud765\ubbf8\ub85c\uc6b8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.)<\/p>\n<p>\uac10\uc0ac\ub294 \uac01 \uc11c\ubc84\uc5d0\uc11c \uac10\uc0ac \uc545\ub9c8\ub77c\ub294 \uc2e4\ud589 \ud30c\uc77c\uc5d0 \uc758\ud574 \uc81c\uc5b4\ub429\ub2c8\ub2e4. \uac10\uc0ac \uc545\ub9c8\ub294 \uac10\uc0ac \ub85c\uadf8\uc5d0 \ubaa8\ub4e0 \ub808\ucf54\ub4dc\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. 5.0\uc5d0\uc11c\ub294 \uac10\uc0ac \uc545\ub9c8\uac00 \uc774\ubca4\ud2b8\uc758 \ubaa8\ub4e0 \ud544\ud130\ub9c1\uc744 \ub2f4\ub2f9\ud588\uace0, \ud074\ub77c\uc774\uc5b8\ud2b8\ub294 \uac10\uc0ac \uac00\ub2a5\ud55c \ubaa8\ub4e0 \uc774\ubca4\ud2b8\uc5d0 \ub300\ud55c \uae30\ub85d\uc744 \uc804\uc1a1\ud558\uba74 \uac10\uc0ac \uc545\ub9c8\uac00 \ud544\ud130\ub9c1 \uad6c\uc131\uc5d0 \ub530\ub77c \ub85c\uadf8\uc5d0 \uac10\uc0ac \uae30\ub85d\uc744 \ub9cc\ub4e4\uac70\ub098 \ub9cc\ub4e4\uc9c0 \uc54a\uc558\uc2b5\ub2c8\ub2e4. \uc548\ud0c0\uae5d\uac8c\ub3c4 \uac10\uc0ac\uac00 \uace0\ub3c4\ub85c \ud544\ud130\ub9c1\ub418\uc5b4 \ud074\ub77c\uc774\uc5b8\ud2b8\uac00 \uc7a0\uc7ac\uc801\uc73c\ub85c \uac10\uc0ac \ub300\uc0c1\uc774 \ub420 \uc218 \uc788\ub294 \ub9ce\uc740 \uc791\uc5c5\uc744 \uc218\ud589\ud558\ub294 \uacbd\uc6b0 \uc774\ub294 \ub9e4\uc6b0 \ube44\ud6a8\uc728\uc801\uc785\ub2c8\ub2e4. \ucffc\ub9ac \uc5d4\uc9c4\uacfc \uac19\uc740 \ud074\ub77c\uc774\uc5b8\ud2b8\ub294 \uc218\ubc31\ub9cc \uac1c\uc758 \ub808\ucf54\ub4dc\ub97c \uc0dd\uc131\ud558\uc9c0\ub9cc \ub3c4\ucc29\ud558\uc790\ub9c8\uc790 \uac10\uc0ac \uc545\ub9c8\uc5d0 \uc758\ud574 \ubc84\ub824\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4849\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/03\/cropped-audit-boxes.jpg\" alt=\"\" width=\"724\" height=\"526\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/cropped-audit-boxes.jpg 724w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/cropped-audit-boxes-300x218.jpg 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/cropped-audit-boxes-20x15.jpg 20w\" sizes=\"auto, (max-width: 724px) 100vw, 724px\" \/><\/p>\n<p>\uc774 \ubb38\uc81c\ub97c \uc644\ud654\ud558\uae30 \uc704\ud574 5.5\uc5d0\uc11c\ub294 Couchbase\uac00 \ud3ec\uc6cc\ub4dc \ud544\ud130\ub9c1\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \ucffc\ub9ac \uc5d4\uc9c4\uc740 \ud604\uc7ac \uac10\uc0ac \uad6c\uc131\uc744 \uc778\uc2dd\ud558\uace0 \ud604\uc7ac \uac10\uc0ac\ub41c \ub808\ucf54\ub4dc\ub9cc \uac10\uc0ac \ub370\ubaac\uc73c\ub85c \ubcf4\ub0c5\ub2c8\ub2e4. \ub610\ud55c \uc0c8 \uad6c\uc131\uc744 \uc218\uc2e0\ud588\uc73c\uba70 \uc774\ub97c \uc778\uc2dd\ud558\uace0 \uc788\uc74c\uc744 \ub098\ud0c0\ub0b4\ub294 \ud2b9\uc218 \uac10\uc0ac \ub808\ucf54\ub4dc\ub97c \ubcf4\ub0c5\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub7ec\ud55c \uc774\uc911 \ud544\ud130\ub9c1\uc73c\ub85c \uc778\ud574 \uac10\uc0ac \ub85c\uadf8\uc5d0 \ub450 \uac00\uc9c0 \uc720\ud615\uc758 \uad6c\uc131 \ub808\ucf54\ub4dc\uac00 \ud45c\uc2dc\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\uc640 \uac19\uc740 \ub808\ucf54\ub4dc\ub294 \uac10\uc0ac \ub370\ubaac\uc774 \uc0c8 \uad6c\uc131\uc744 \uc218\uc2e0\ud588\uc74c\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4:<\/p>\n<pre>{\"rotate_size\":20971520,\"log_path\":\"\/Users\/johanlarson\/Library\/Application Support\/Couchbase\/var\/lib\/couchbase\/logs\",\"rotate_interval\":86400,\r\n\"disabled_userids\":[],\"auditd_enabled\":true,\r\n\"disabled\":[20485,20488,20489,20490,20491,28673,28675,28676,28677,28678,28679,28680,28681,28682,\r\n 28683,28684,28685,28686,28687,28688,28689,28690,28691,28692,28693,28694,28695,28697,28698,28699,\r\n28700,28701,28702,32770,32771,32772,32780],\r\n\"enabled:[20480,20482,20483,28672,28674,32768,32769,32773,32774,32775,32776,32777,32778,32779,32781,32782],\r\n\"real_userid\":{\"source\":\"ns_server\",\"user\":\"Administrator\"},\"sessionid\":\"8b3d16bffa8444ce596b64a78c0185f7\",\r\n\"remote\":{\"ip\":\"127.0.0.1\",\"port\":52153},\r\n\"timestamp\":\"2018-03-14T06:25:30.370-07:00\",\"id\":8240,\"name\":\"configured audit daemon\",\r\n\"description\":\"loaded configuration file for audit daemon\"}\r\n<\/pre>\n<p>\uadf8\ub9ac\uace0 \uc774\uc640 \uac19\uc740 \ub808\ucf54\ub4dc\ub294 \ucffc\ub9ac \uc5d4\uc9c4\uc774 \uc0c8 \uad6c\uc131\uc744 \uc218\uc2e0\ud588\uc74c\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4:<\/p>\n<pre>{\"timestamp\":\"2018-03-14T06:25:30.427-07:00\",\r\n\"real_userid\":{\"source\":\"\",\"user\":\"\"},\"uuid\":\"26571424\",\"id\":28703,\r\n\"name\":\"N1QL configuration\",\"description\":\"States that N1QL is using audit configuration with specified uuid\"}\r\n<\/pre>\n<p>\uad6c\uc131\uc744 \uc2dd\ubcc4\ud558\ub294 UUID\uc5d0 \uc8fc\ubaa9\ud558\uc138\uc694. \ub2e4\uc74c\uacfc \uac19\uc774 \uad6c\uc131\uc5d0\uc11c \uc774 UUID\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n<p><code>curl https:\/\/localhost:8091\/pools\/default -u \uad00\ub9ac\uc790:\ube44\ubc00\ubc88\ud638<\/code><\/p>\n<p>\"auditUid\" \ud544\ub4dc\ub97c \ucc3e\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\uc74c\uacfc \uac19\uc774 \uc804\uccb4 \uac10\uc0ac \uad6c\uc131\uc744 \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n<p><code>curl https:\/\/localhost:8091\/settings\/audit -u \uad00\ub9ac\uc790:\ube44\ubc00\ubc88\ud638<\/code><\/p>\n<pre>{\"disabled\":[20485,20488,20489,20490,20491,28673,28675,28676,28677,28678,\r\n28679,28680,28681,28682,28683,28684,28685,28686,28687,28688,28689,\r\n28690,28691,28692,28693,28694,28695,28698,28699,28700,28701,28702,\r\n32770,32771,32772,32780],\r\n\"uid\":\"18635804\",\"auditdEnabled\":true,\"disabledUsers\":[],\r\n\"logPath\":\"\/Users\/johanlarson\/Library\/Application Support\/Couchbase\/var\/lib\/couchbase\/logs\",\r\n\"rotateInterval\":86400,\"rotateSize\":20971520}\r\n<\/pre>\n<h4>\uac10\uc0ac \ub85c\uadf8 \ub85c\ub4dc<\/h4>\n<p>\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc11c\ubc84\ub294 \ud604\uc7ac \uac10\uc0ac \ub808\ucf54\ub4dc\uc5d0 \ub300\ud574 \uc11c\ubc84\uc758 \ud30c\uc77c\uc774\ub77c\ub294 \ud558\ub098\uc758 \ub300\uc0c1\ub9cc \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ub54c\ub85c\ub294 \uac10\uc0ac \ub808\ucf54\ub4dc\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc790\uccb4\ub85c \uac00\uc838\uc624\ub294 \uac83\uc774 \uc720\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uac10\uc0ac \ub808\ucf54\ub4dc\ub294 JSON\uc774\ubbc0\ub85c \uc5b4\ub835\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ub85c\uadf8\ub97c \ub85c\ub4dc\ud558\ub824\uba74 cbimport\ub77c\ub294 \uc720\ud2f8\ub9ac\ud2f0\ub97c \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p>Mac\uc758 \ud45c\uc900 \uc704\uce58\uc5d0 \uac10\uc0ac \ub85c\uadf8\uac00 \uc788\uace0 '\ud14c\uc2a4\ud2b8' \ubc84\ud0b7\uc744 \ub9cc\ub4e4\uc5c8\ub2e4\ub294 \uac00\uc815 \ud558\uc5d0, \uc774 \uc8fc\ubb38\uc740 audit.log \ud30c\uc77c\uc744 '\ud14c\uc2a4\ud2b8' \ubc84\ud0b7\uc5d0 \ub85c\ub4dc\ud569\ub2c8\ub2e4:<\/p>\n<p><code>\/Applications\/CouchBase\\ Server.app\/Contents\/Resources\/couchbase-core\/bin\/cbimport json -c https:\/\/localhost:8091 -u \uad00\ub9ac\uc790 -p \ube44\ubc00\ubc88\ud638 -b \ud14c\uc2a4\ud2b8 -g \"#UUID#\" -d file:\/\/\/Users\/johanlarson\/Library\/Application\\ Support\/CouchBase\/var\/lib\/couchbase\/logs\/audit.log -f lines<\/code><\/p>\n<p>\uc774\ub294 \ubc1b\uc544\ub4e4\uc774\uae30\uc5d0\ub294 \ub2e4\uc18c \ub9ce\uc740 \uc591\uc774\uba70 \ub2e4\ub978 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \uc57d\uac04 \ub2e4\ub978 \ubcc0\ud615\uc774 \ud544\uc694\ud558\ubbc0\ub85c \ub2e8\uacc4\ubcc4\ub85c \uc0b4\ud3b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li><strong>\/\uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\/\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\\ \uc11c\ubc84.\uc571\/\ucf58\ud150\uce20\/\ub9ac\uc18c\uc2a4\/couchbase-core\/bin\/cbimport<\/strong> \ub294 Mac\uc5d0\uc11c cbimport \uba85\ub839\uc758 \uc804\uccb4 \uacbd\ub85c\uc785\ub2c8\ub2e4. \ub2e4\ub978 \uc2dc\uc2a4\ud15c\uc758 \uacbd\uc6b0 \uc720\ud2f8\ub9ac\ud2f0\ub294 \ub2e4\ub978 \uacf3\uc5d0 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc138\uc694. <a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/5.1\/cli\/cli-intro.html\">\uc774 \ubb38\uc11c<\/a>.<\/li>\n<li><strong>-c https:\/\/localhost:8091<\/strong> \ub294 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uac00 \uc2e4\ud589\ub418\uace0 \uc788\ub294 \uc11c\ubc84\uc758 URL\uc785\ub2c8\ub2e4.<\/li>\n<li><strong>-u \uad00\ub9ac\uc790 -p \ube44\ubc00\ubc88\ud638<\/strong> \ub294 \ub370\uc774\ud130\ub97c \uc5c5\ub85c\ub4dc\ud558\ub294 \uc0ac\uc6a9\uc790\uc758 \uc0ac\uc6a9\uc790 \uc544\uc774\ub514\uc640 \ube44\ubc00\ubc88\ud638\uc785\ub2c8\ub2e4(\uc774 \uacbd\uc6b0 \uae30\ubcf8 \uad00\ub9ac\uc790).<\/li>\n<li><strong>-b \ud14c\uc2a4\ud2b8<\/strong> \ub294 \ub370\uc774\ud130\ub97c \uc5c5\ub85c\ub4dc\ud560 \ubc84\ud0b7\uc758 \uc774\ub984\uc785\ub2c8\ub2e4.<\/li>\n<li><strong>-g \"#UUID#\"<\/strong> \ub294 \ubc84\ud0b7\uc5d0 \uc785\ub825\ub41c \uac01 \ubb38\uc11c\uc5d0 \ub300\ud574 \uc0dd\uc131\ud560 \ud0a4\uc758 \uc720\ud615\uc785\ub2c8\ub2e4. \uc774 \uacbd\uc6b0\uc5d0\ub294 UUID\ub97c \uc0ac\uc6a9\ud558\uace0 \uc788\uc9c0\ub9cc \ub2e4\ub978 \ub9ce\uc740 \uc635\uc158\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ubc84\ud0b7\uc758 <a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/current\/tools\/cbimport.html\">cbimport<\/a> \ubb38\uc11c\uc5d0\uc11c \uc790\uc138\ud55c \ub0b4\uc6a9\uc744 \ud655\uc778\ud558\uc138\uc694.<\/li>\n<li><strong>-d file:\/\/\/Users\/johanlarson\/Library\/Application\\ Support\/Couchbase\/var\/lib\/couchbase\/logs\/audit.log<\/strong> \ub294 \uac10\uc0ac \ub85c\uadf8\uc758 \uc704\uce58\ub97c \uac00\ub9ac\ud0a4\ub294 \ud30c\uc77c URL\uc785\ub2c8\ub2e4. URL \uacbd\ub85c\uc5d0 \uacf5\ubc31\uc744 \ud5c8\uc6a9\ud558\uae30 \uc704\ud574 \uc2ac\ub798\uc2dc \uc138 \uac1c\uc640 \ubc31\uc2ac\ub798\uc2dc\ub97c \uc0ac\uc6a9\ud558\uc138\uc694. \uac10\uc0ac \ub85c\uadf8\ub97c \ud3ec\ud568\ud55c \ub85c\uadf8\ub294 \uc2dc\uc2a4\ud15c\ub9c8\ub2e4 \ub2e4\ub978 \ud45c\uc900 \ub514\ub809\ud130\ub9ac\uc5d0 \ubc30\uce58\ub429\ub2c8\ub2e4. \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc138\uc694. <a href=\"https:\/\/docs.couchbase.com\/server\/current\/manage\/manage-logging\/manage-logging.html\">\uc774 \ubb38\uc11c<\/a> \uc5d0\uc11c \uc790\uc138\ud55c \ub0b4\uc6a9\uc744 \ud655\uc778\ud558\uc138\uc694.<\/li>\n<\/ul>\n<p>\uac10\uc0ac \uae30\ub85d\uc774 \uc2dc\uc2a4\ud15c\uc5d0 \uc788\uc73c\uba74 \ub2e4\ub978 \ub370\uc774\ud130\uc640 \ub9c8\ucc2c\uac00\uc9c0\ub85c \ucffc\ub9ac\ud560 \uc218 \uc788\uc73c\uba70, \ucffc\ub9ac \uc6cc\ud06c\ubca4\uce58\ub85c \uc774\ub3d9\ud558\uc5ec \uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694.<\/p>\n<p>\uc774 \ucffc\ub9ac\ub294 \uc5bc\ub9c8\ub098 \ub9ce\uc740 \uac10\uc0ac \ub808\ucf54\ub4dc\uac00 \uc788\ub294\uc9c0 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4:<\/p>\n<p><code>SELECT COUNT(*) AS NUM FROM TEST<\/code><\/p>\n<p>\uadf8\ub9ac\uace0 \uc774 \ucffc\ub9ac\ub294 \uac10\uc0ac \ub808\ucf54\ub4dc \uc720\ud615\ubcc4\ub85c \uac1c\uc218\ub97c \uc138\ubd84\ud654\ud569\ub2c8\ub2e4:<\/p>\n<p><code>\uc774\ub984\ubcc4 \ud14c\uc2a4\ud2b8 \uadf8\ub8f9\uc5d0\uc11c \uc774\ub984, \uce74\uc6b4\ud2b8(*)\ub97c NUM\uc73c\ub85c \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/code><\/p>\n<h4>\uc694\uc57d<\/h4>\n<ul>\n<li>\ucffc\ub9ac \uc5d4\uc9c4\uc5d0 \ub300\ud55c \uc694\uccad\uc740 \ub2e4\uc74c \ub0a0\uc9dc\ubd80\ud130 \uac10\uc0ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/announcing-couchbase-server-5-5\/\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc11c\ubc84 5.5<\/a> EE.<\/li>\n<li>\uac10\uc0ac\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \uc774\ubca4\ud2b8 \uc720\ud615\ubcc4 \ud544\ud130\ub9c1\uacfc \uc0ac\uc6a9\uc790 \ud654\uc774\ud2b8\ub9ac\uc2a4\ud2b8\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4.<\/li>\n<li>\uc694\uccad\uc740 \ucffc\ub9ac \uc720\ud615 \ubc0f API \uc5d4\ub4dc\ud3ec\uc778\ud2b8\ubcc4\ub85c \uc774\ubca4\ud2b8\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/li>\n<li>N1QL \ubb38 \uac10\uc0ac\uc5d0 \ub300\ud55c \ucd94\uac00 \ubb38\uc11c\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/5.5\/security\/n1ql-auditing.html\" target=\"_blank\" rel=\"noopener noreferrer\">\uc5ec\uae30<\/a>.<\/li>\n<li><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/downloads\/\">Couchbase Server 5.5 \ub2e4\uc6b4\ub85c\ub4dc<\/a> \uc5ec\uae30\ub97c \ud074\ub9ad\ud558\uc138\uc694.<\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Couchbase Server 5.5 includes the ability to keep a record of all N1QL actions taken by users. This is part of Couchbase&#8217;s more general audit functionality, introduced in 5.0. Auditing is only available in Enterprise edition. Auditing lets the administrators [&hellip;]<\/p>","protected":false},"author":8157,"featured_media":4846,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1816,1812],"tags":[2258,2180,2182],"ppma_author":[9058],"class_list":["post-4841","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-couchbase-server","category-n1ql-query","tag-5-5","tag-auditing","tag-devbuild"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.5 (Yoast SEO v26.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Auditing Couchbase N1QL Statements - The Couchbase Blog<\/title>\n<meta name=\"description\" content=\"Couchbase Server now supports auditing of N1QL statements and API accesses. This article shows how, including hands-on exercises.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/ko\/auditing-couchbase-n1ql-statements\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Auditing Couchbase N1QL Statements\" \/>\n<meta property=\"og:description\" content=\"Couchbase Server now supports auditing of N1QL statements and API accesses. This article shows how, including hands-on exercises.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/auditing-couchbase-n1ql-statements\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-19T15:41:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T00:22:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/0215-surveillance-jpg.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"804\" \/>\n\t<meta property=\"og:image:height\" content=\"603\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Johan Larson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Johan Larson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/\"},\"author\":{\"name\":\"Johan Larson\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/043ccbbfc54b95927c73f81ec7f6a0a1\"},\"headline\":\"Auditing Couchbase N1QL Statements\",\"datePublished\":\"2018-03-19T15:41:48+00:00\",\"dateModified\":\"2025-06-14T00:22:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/\"},\"wordCount\":2055,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/0215-surveillance-jpg.jpg\",\"keywords\":[\"5.5\",\"auditing\",\"devbuild\"],\"articleSection\":[\"Couchbase Server\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/\",\"name\":\"Auditing Couchbase N1QL Statements - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/0215-surveillance-jpg.jpg\",\"datePublished\":\"2018-03-19T15:41:48+00:00\",\"dateModified\":\"2025-06-14T00:22:38+00:00\",\"description\":\"Couchbase Server now supports auditing of N1QL statements and API accesses. This article shows how, including hands-on exercises.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/0215-surveillance-jpg.jpg\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/0215-surveillance-jpg.jpg\",\"width\":804,\"height\":603},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Auditing Couchbase N1QL Statements\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/043ccbbfc54b95927c73f81ec7f6a0a1\",\"name\":\"Johan Larson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/93b175bb8728e12439dd573fc27b9d1a\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2ddf616344da1f84e85c42ba2bfc102e28380128c107cc21eeecc26edc737227?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2ddf616344da1f84e85c42ba2bfc102e28380128c107cc21eeecc26edc737227?s=96&d=mm&r=g\",\"caption\":\"Johan Larson\"},\"description\":\"Johan Larson is a Senior Software Engineer at Couchbase. Johan's work responsibility is building an SQL-based query language for JSON data in a distributed NoSQL system.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/johan-larson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Auditing Couchbase N1QL Statements - The Couchbase Blog","description":"\uc774\uc81c Couchbase Server\uc5d0\uc11c N1QL \ubb38 \ubc0f API \uc561\uc138\uc2a4\uc5d0 \ub300\ud55c \uac10\uc0ac\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uc774 \ubb38\uc11c\uc5d0\uc11c\ub294 \uc2e4\uc2b5\uc744 \ud3ec\ud568\ud558\uc5ec \uadf8 \ubc29\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/ko\/auditing-couchbase-n1ql-statements\/","og_locale":"ko_KR","og_type":"article","og_title":"Auditing Couchbase N1QL Statements","og_description":"Couchbase Server now supports auditing of N1QL statements and API accesses. This article shows how, including hands-on exercises.","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/auditing-couchbase-n1ql-statements\/","og_site_name":"The Couchbase Blog","article_published_time":"2018-03-19T15:41:48+00:00","article_modified_time":"2025-06-14T00:22:38+00:00","og_image":[{"width":804,"height":603,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/0215-surveillance-jpg.jpg","type":"image\/jpeg"}],"author":"Johan Larson","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Johan Larson","Est. reading time":"11\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/"},"author":{"name":"Johan Larson","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/043ccbbfc54b95927c73f81ec7f6a0a1"},"headline":"Auditing Couchbase N1QL Statements","datePublished":"2018-03-19T15:41:48+00:00","dateModified":"2025-06-14T00:22:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/"},"wordCount":2055,"commentCount":2,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/0215-surveillance-jpg.jpg","keywords":["5.5","auditing","devbuild"],"articleSection":["Couchbase Server","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/","url":"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/","name":"Auditing Couchbase N1QL Statements - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/0215-surveillance-jpg.jpg","datePublished":"2018-03-19T15:41:48+00:00","dateModified":"2025-06-14T00:22:38+00:00","description":"\uc774\uc81c Couchbase Server\uc5d0\uc11c N1QL \ubb38 \ubc0f API \uc561\uc138\uc2a4\uc5d0 \ub300\ud55c \uac10\uc0ac\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uc774 \ubb38\uc11c\uc5d0\uc11c\ub294 \uc2e4\uc2b5\uc744 \ud3ec\ud568\ud558\uc5ec \uadf8 \ubc29\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/0215-surveillance-jpg.jpg","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/0215-surveillance-jpg.jpg","width":804,"height":603},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/auditing-couchbase-n1ql-statements\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Auditing Couchbase N1QL Statements"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","description":"NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4, Couchbase","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/043ccbbfc54b95927c73f81ec7f6a0a1","name":"\uc694\ud55c \ub77c\uc2a8","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/93b175bb8728e12439dd573fc27b9d1a","url":"https:\/\/secure.gravatar.com\/avatar\/2ddf616344da1f84e85c42ba2bfc102e28380128c107cc21eeecc26edc737227?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2ddf616344da1f84e85c42ba2bfc102e28380128c107cc21eeecc26edc737227?s=96&d=mm&r=g","caption":"Johan Larson"},"description":"\uc694\ud55c \ub77c\uc2a8\uc740 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc758 \uc120\uc784 \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc5d4\uc9c0\ub2c8\uc5b4\uc785\ub2c8\ub2e4. Johan\uc740 \ubd84\uc0b0\ud615 NoSQL \uc2dc\uc2a4\ud15c\uc5d0\uc11c JSON \ub370\uc774\ud130\ub97c \uc704\ud55c SQL \uae30\ubc18 \ucffc\ub9ac \uc5b8\uc5b4\ub97c \uad6c\ucd95\ud558\ub294 \uc5c5\ubb34\ub97c \ub2f4\ub2f9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.","url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/johan-larson\/"}]}},"authors":[{"term_id":9058,"user_id":8157,"is_guest":0,"slug":"johan-larson","display_name":"Johan Larson","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/2ddf616344da1f84e85c42ba2bfc102e28380128c107cc21eeecc26edc737227?s=96&d=mm&r=g","author_category":"","last_name":"Larson","first_name":"Johan","job_title":"","user_url":"","description":"\uc694\ud55c \ub77c\uc2a8\uc740 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc758 \uc120\uc784 \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc5d4\uc9c0\ub2c8\uc5b4\uc785\ub2c8\ub2e4. Johan\uc740 \ubd84\uc0b0\ud615 NoSQL \uc2dc\uc2a4\ud15c\uc5d0\uc11c JSON \ub370\uc774\ud130\ub97c \uc704\ud55c SQL \uae30\ubc18 \ucffc\ub9ac \uc5b8\uc5b4\ub97c \uad6c\ucd95\ud558\ub294 \uc5c5\ubb34\ub97c \ub2f4\ub2f9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/4841","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/users\/8157"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=4841"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/4841\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/4846"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=4841"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=4841"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=4841"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=4841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}