{"id":2483,"date":"2018-01-28T15:55:49","date_gmt":"2018-01-28T06:55:49","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2483"},"modified":"2018-01-28T15:55:49","modified_gmt":"2018-01-28T06:55:49","slug":"db-security-oracle-ms-sql-mysql-%ec%9d%98-db-%eb%b3%b4%ec%95%88-%ec%84%a4%ec%a0%95-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2483","title":{"rendered":"[DB Security] ORACLE, MS-SQL, MySQL \uc758 DB \ubcf4\uc548 \uc124\uc815 \ubc29\ubc95"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>ORACLE, MS-SQL, MySQL \uc758 DB \ubcf4\uc548 \uc124\uc815 \ubc29\ubc95 \ubb38\uc11c\uc785\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><a href=\"#_bookmark1\">\uacc4\uc815 \uad00\ub9ac&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;.. 2<\/a>\n<ul>\n<li><a href=\"#_bookmark2\">\uae30\ubcf8 \uacc4\uc815\uc758\u00a0\u00a0 \ud328\uc2a4\uc6cc\ub4dc,\u00a0\u00a0 \uc815\ucc45\u00a0 \ub4f1\uc744 \ubcc0\uacbd\ud558\uc5ec \u00a0\uc0ac\uc6a9&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;.. 2<\/a><\/li>\n<li><a href=\"#_bookmark3\">scott \ub4f1\u00a0 Demonstration\u00a0 \ubc0f\u00a0 \ubd88\ud544\uc694\u00a0 \uacc4\uc815\uc744\u00a0 \uc81c\uac70\ud558\uac70\ub098\u00a0 \uc7a0\uae08\u00a0 \uc124\uc815 \u00a0\ud6c4 \u00a0\uc0ac\uc6a9&#8230;. 4<\/a><\/li>\n<li><a href=\"#_bookmark4\">\ud328\uc2a4\uc6cc\ub4dc\uc758 \uc0ac\uc6a9\uae30\uac04\u00a0 \ubc0f\u00a0 \ubcf5\uc7a1\ub3c4\u00a0 \uae30\uad00\u00a0 \uc815\ucc45\uc5d0 \ub9de\ub3c4\ub85d \uc124\uc815&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230; 5<\/a><\/li>\n<li><a href=\"#_bookmark5\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc790\u00a0 \uad8c\ud55c\uc744\u00a0 \uaf2d\u00a0 \ud544\uc694\ud55c\u00a0 \uacc4\uc815\u00a0 \ubc0f \uadf8\ub8f9\uc5d0 \ud5c8\uc6a9&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230; 8<\/a><\/li>\n<li><a href=\"#_bookmark6\">\ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc0ac\uc6a9\uc5d0 \u00a0\ub300\ud55c \u00a0\uc81c\uc57d&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230; 10<\/a><\/li>\n<li><a href=\"#_bookmark7\">DB \uc0ac\uc6a9\uc790\u00a0\u00a0 \uacc4\uc815 \uac1c\ubcc4\uc801 \u00a0\ubd80\uc5ec&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230; 11<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#_bookmark8\">\uc811\uadfc\uad00\ub9ac&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;. 13<\/a>\n<ul>\n<li><a href=\"#_bookmark9\">\uc6d0\uaca9\uc5d0\uc11c DB\u00a0\u00a0 \uc11c\ubc84\ub85c\uc758 \uc811\uc18d \u00a0\uc81c\ud55c&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;.. 13<\/a><\/li>\n<li><a href=\"#_bookmark10\">DBA\uc774\uc678\uc758 \uc778\uac00\ub418\uc9c0 \u00a0\uc54a\uc740 \u00a0\uc0ac\uc6a9\uc790 \u00a0\uc2dc\uc2a4\ud15c \u00a0\ud14c\uc774\ube14 \u00a0\uc811\uadfc \u00a0\uc81c\ud55c \u00a0\uc124\uc815&#8230;&#8230;&#8230; 15<\/a><\/li>\n<li><a href=\"#_bookmark11\">\uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758\u00a0 \uacbd\uc6b0\u00a0 \ub9ac\uc2a4\ub108 \ud328\uc2a4\uc6cc\ub4dc \uc124\uc815&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;.. 17<\/a><\/li>\n<li><a href=\"#_bookmark12\">\ubd88\ud544\uc694\ud55c ODBC\/OLE-DB\u00a0 \ub370\uc774\ud130\u00a0 \uc18c\uc2a4\uc640 \u00a0\ub4dc\ub77c\uc774\ube0c \u00a0\uc81c\uac70&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;. 18<\/a><\/li>\n<li><a href=\"#_bookmark13\">\uc77c\uc815 \ud69f\uc218\uc758\u00a0 \ub85c\uadf8\uc778\u00a0 \uc2e4\ud328\u00a0 \uc2dc\u00a0 \uc7a0\uae08 \uc815\ucc45 \uc124\uc815&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;. 19<\/a><\/li>\n<li><a href=\"#_bookmark14\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc8fc\uc694 \u00a0\ud30c\uc77c \u00a0\ubcf4\ud638 \u00a0\ub4f1\uc744 \u00a0\uc704\ud574 \u00a0DB \u00a0\uacc4\uc815\uc758 \u00a0umask\ub97c \u00a0022 \u00a0\uc774\uc0c1\uc73c\ub85c \u00a0\uc124\uc815\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 20<\/a><\/li>\n<li><a href=\"#_bookmark15\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc8fc\uc694\u00a0 \uc124\uc815\ud30c\uc77c,\u00a0 \ud328\uc2a4\uc6cc\ub4dc\u00a0 \ud30c\uc77c\u00a0 \ub4f1\u00a0 \uc8fc\uc694\u00a0 \ud30c\uc77c\ub4e4\uc758\u00a0 \uc811\uadfc \uad8c\ud55c \uc124\uc815\u00a0\u00a0\u00a0\u00a0 21<\/a><\/li>\n<li><a href=\"#_bookmark16\">\uad00\ub9ac\uc790 \uc774\uc678\uc758\u00a0 \uc0ac\uc6a9\uc790\uac00\u00a0 \uc624\ub77c\ud074\u00a0 \ub9ac\uc2a4\ub108\uc758\u00a0 \uc811\uc18d\uc744\u00a0 \ud1b5\ud574\u00a0 \ub9ac\uc2a4\ub108\u00a0 \ub85c\uadf8\u00a0\u00a0 \ubc0f\u00a0\u00a0 trace\u00a0 \ud30c\uc77c\uc5d0\u00a0 \ub300<\/a>\u00a0 <a href=\"#_bookmark16\">\u00a0\ud55c\u00a0\u00a0 \ubcc0\uacbd \uad8c\ud55c \u00a0\uc81c\ud55c&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230; 23<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#_bookmark17\">\uc635\uc158\uad00\ub9ac&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;. 24<\/a>\n<ul>\n<li><a href=\"#_bookmark18\">\uc751\uc6a9\ud504\ub85c\uadf8\ub7a8 \ub610\ub294\u00a0 DBA\u00a0 \uacc4\uc815\uc758\u00a0 Role\uc774\u00a0 Public\uc73c\ub85c\u00a0 \uc124\uc815\ub418\uc9c0\u00a0 \u00a0\uc54a\ub3c4\ub85d \u00a0\uc870\uc815&#8230; 24<\/a><\/li>\n<li><a href=\"#_bookmark19\">OS_ROLES, REMOTE_OS_AUTHENTICATION, REMOTE_OS_ROLES\ub97c FALSE\ub85c \uc124\uc815.. 25<\/a><\/li>\n<li><a href=\"#_bookmark20\">\ud328\uc2a4\uc6cc\ub4dc \ud655\uc778\ud568\uc218\uac00 \u00a0\uc124\uc815\ub418\uc5b4 \u00a0\uc801\uc6a9\ub418\ub294\uac00?&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230; 26<\/a><\/li>\n<li><a href=\"#_bookmark21\">\uc778\uac00\ub418\uc9c0 \uc54a\uc740\u00a0 Object\u00a0 Owner\uac00 \uc874\uc7ac\ud558\uc9c0 \u00a0\uc54a\ub294\uac00?&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230; 28<\/a><\/li>\n<li><a href=\"#_bookmark22\">grant option\uc774\u00a0\u00a0 role\uc5d0\u00a0\u00a0 \uc758\ud574 \ubd80\uc5ec\ub418\ub3c4\ub85d \u00a0\uc124\uc815&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;. 29<\/a><\/li>\n<li><a href=\"#_bookmark23\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc790\uc6d0\u00a0 \uc81c\ud55c\u00a0 \uae30\ub2a5\uc744\u00a0 \u00a0TRUE\ub85c \u00a0\uc124\uc815&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;. 30<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#_bookmark24\">\ud328\uce58\uad00\ub9ac&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;. 31<\/a>\n<ul>\n<li><a href=\"#_bookmark25\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub300\ud574\u00a0 \ucd5c\uc2e0\u00a0 \ubcf4\uc548\ud328\uce58\uc640\u00a0 \ubc34\ub354\u00a0 \uad8c\uace0\uc0ac\ud56d\uc744 \ubaa8\ub450 \uc801\uc6a9&#8230;&#8230;&#8230;&#8230;&#8230;.. 31<\/a><\/li>\n<li><a href=\"#_bookmark26\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc811\uadfc, \ubcc0\uacbd,\u00a0 \uc0ad\uc81c\u00a0 \ub4f1\uc758\u00a0 \uac10\uc0ac\uae30\ub85d\uc774\u00a0 \uae30\uad00\uc758\u00a0 \uac10\uc0ac\uae30\ub85d\u00a0 \uc815\ucc45\uc5d0\u2019\u00a0 \uc801\ud569\ud558\ub3c4\ub85d<\/a> <a href=\"#_bookmark26\">\u00a0\uc124\uc815\u00a0\u00a0\u00a0 34<\/a><\/li>\n<li><a href=\"#_bookmark27\">\ubcf4\uc548\uc5d0 \ucde8\uc57d\ud558\uc9c0\u00a0 \uc54a\uc740\u00a0 \ubc84\uc804\uc758\u00a0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uace0 \uc788\ub294\uac00?&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;. 36<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#_bookmark28\">\ub85c\uadf8\uad00\ub9ac&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;. 37<\/a><\/li>\n<\/ul>\n<p><a href=\"#_bookmark29\">Audit\u00a0 Table\uc740\u00a0\u00a0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\u00a0 \uad00\ub9ac\uc790\u00a0 \uacc4\uc815\uc5d0\u00a0 \uc18d\ud574 \uc788\ub3c4\ub85d \u00a0\uc124\uc815\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 37<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&lt; \ub0b4\uc6a9 \ud655\uc778 &gt;<\/p>\n<p><a href=\"http:\/\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/DBMS\ubcc4-\ubcf4\uc548-\uc124\uc815-\ubc29\ubc95ORACLEMSSQLMYSQL.pdf\">DBMS\ubcc4 \ubcf4\uc548 \uc124\uc815 \ubc29\ubc95(ORACLE+MSSQL+MYSQL)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; ORACLE, MS-SQL, MySQL \uc758 DB \ubcf4\uc548 \uc124\uc815 \ubc29\ubc95 \ubb38\uc11c\uc785\ub2c8\ub2e4. &nbsp; \uacc4\uc815 \uad00\ub9ac&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;.. 2 \uae30\ubcf8 \uacc4\uc815\uc758\u00a0\u00a0 \ud328\uc2a4\uc6cc\ub4dc,\u00a0\u00a0 \uc815\ucc45\u00a0 \ub4f1\uc744 \ubcc0\uacbd\ud558\uc5ec \u00a0\uc0ac\uc6a9&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;.. 2 scott \ub4f1\u00a0 Demonstration\u00a0 \ubc0f\u00a0 \ubd88\ud544\uc694\u00a0 \uacc4\uc815\uc744\u00a0 \uc81c\uac70\ud558\uac70\ub098\u00a0 \uc7a0\uae08\u00a0 \uc124\uc815 \u00a0\ud6c4 \u00a0\uc0ac\uc6a9&#8230;. 4 \ud328\uc2a4\uc6cc\ub4dc\uc758 \uc0ac\uc6a9\uae30\uac04\u00a0 \ubc0f\u00a0 \ubcf5\uc7a1\ub3c4\u00a0 \uae30\uad00\u00a0 \uc815\ucc45\uc5d0 \ub9de\ub3c4\ub85d \uc124\uc815&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230; 5 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc790\u00a0 \uad8c\ud55c\uc744\u00a0 \uaf2d\u00a0 \ud544\uc694\ud55c\u00a0 \uacc4\uc815\u00a0 \ubc0f \uadf8\ub8f9\uc5d0 \ud5c8\uc6a9&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230; 8 \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc0ac\uc6a9\uc5d0 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2425,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[336],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/1382737.jpg?fit=450%2C299","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2483"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2483"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2483\/revisions"}],"predecessor-version":[{"id":2485,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2483\/revisions\/2485"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2425"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2483"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}