{"id":693,"date":"2015-11-23T02:30:38","date_gmt":"2015-11-23T02:30:38","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=693"},"modified":"2015-11-23T02:30:38","modified_gmt":"2015-11-23T02:30:38","slug":"sqlplus-securityproductuserprofile","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=693","title":{"rendered":"SQL*PLUS Security(PRODUCT_USER_PROFILE)"},"content":{"rendered":"<p><P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">User \ubcc4\ub85c SQL*PLUS \uc790\uccb4\uc5d0 \ubcc4\ub3c4\uc758 \uc81c\uc57d\uc744 \ud574\uc8fc\uc9c0 \uc54a\uc73c\uba74 \ubcf4\uc548\uc0c1 \ubb38\uc81c\uac00 \ub420 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\ud55c \uc608\ub85c \ud074\ub77c\uc774\uc5b8\ud2b8\ub97c \ud1b5\ud558\uc5ec \ud130\ubbf8\ub110\ub85c \uc811\uc18d\uc744 \ud558\uc5ec HOST(!) \uba85\ub839\uc5b4\ub97c \ud1b5\ud558\uc5ec OS \ub85c \uc811\uc18d\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">User \ubcc4\ub85c \uac01 \uba85\ub839\uc5b4\ub97c \uc218\ud589 \ud560 \uc218 \uc5c6\uac8c\ub054 \uc81c\uc57d\uc744 \ub458 \uc218\uac00 \uc788\ub294\ub370 \uc544\ub798\uc640 \uac19\uc740 Table\uc744 \uc774\uc6a9\ud558\uc5ec \uc81c\uc57d\uc744 \uc904 \uc218\uac00 \uc788\uc2b5\ub2c8\ub2e4. <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile22.uf.260C044856527A4B0DBF86.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">&#8212; SQL*PLUS \uc640 SQL,PL\/SQL \uc744 \uc544\ub798\uc758 \uba85\ub839\uc5b4\ub4e4\uc744 \ucee8\ud2b8\ub864 \ubabb \ud558\uac8c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/SPAN><\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile4.uf.252CDC4F56527A4C18329C.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile25.uf.270B1F4556527A4D298903.png?w=640\" data-recalc-dims=\"1\" \/><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\"> <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\ud574\ub2f9 PRODUCT_USER_PROFILE\uc740 SYSTEM User \ub85c \ucee8\ud2b8\ub864\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SCOTT User \uc758 HOST\uba85\ub839\uc5b4\ub97c DISABLE \uc2dc\ucf1c\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<UL><br \/>\n<LI><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SCOTT User \uc758 Host \uba85\ub839\uc5b4 \uc0ac\uc6a9 \uac00\ub2a5 \uc0c1\ud0dc \ud655\uc778. <\/SPAN><\/LI><\/UL><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; conn scott\/tiger <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Connected. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; host <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">[oracle@rac1 ~]$ exit <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; ! <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">[oracle@rac1 ~]$ <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<UL><br \/>\n<LI><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SYSTEM User \ub85c \uc811\uc18d\ud558\uc5ec Insert <\/SPAN><\/LI><\/UL><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; conn system\/oracle <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Connected. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; <STRONG>INSERT INTO PRODUCT_USER_PROFILE VALUES (&#8216;SQL*Plus&#8217;, &#8216;SCOTT&#8217;, &#8216;HOST&#8217;, NULL, NULL, &#8216;DISABLED&#8217;, NULL, NULL);<\/STRONG> <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">1 row created. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; select * from PRODUCT_USER_PROFILE; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">PRODUCT USERID ATTRIBUTE SCOPE NUMERIC_VALUE CHAR_VALUE DATE_VALU LONG_VALUE <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL*Plus SCOTT HOST&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DISABLED <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<UL><br \/>\n<LI><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SCOTT User \ub85c \uc811\uc18d\ud574\uc11c Host \uba85\ub839\uc5b4 \uc218\ud589 <\/SPAN><\/LI><\/UL><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; conn scott\/tiger <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">Connected. <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; host <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SP2-0544: Command &#8220;host&#8221; disabled in Product User Profile <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SQL&gt; ! <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SP2-0544: Command &#8220;! (HOST)&#8221; disabled in Product User Profile <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\uc704\uc640 \uac19\uc774 PRODUCT_USER_PROFILE \ub97c \ud1b5\ud574 Host \uc774\uc678\uc5d0 select,alter \ub4f1\uc744 User\uac00 \ucee8\ud2b8\ub864 \ud558\uc9c0 \ubabb\ud558\uac8c \ub9c9\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/SPAN><\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>User \ubcc4\ub85c SQL*PLUS \uc790\uccb4\uc5d0 \ubcc4\ub3c4\uc758 \uc81c\uc57d\uc744 \ud574\uc8fc\uc9c0 \uc54a\uc73c\uba74 \ubcf4\uc548\uc0c1 \ubb38\uc81c\uac00 \ub420 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \ud55c \uc608\ub85c \ud074\ub77c\uc774\uc5b8\ud2b8\ub97c \ud1b5\ud558\uc5ec \ud130\ubbf8\ub110\ub85c \uc811\uc18d\uc744 \ud558\uc5ec HOST(!) \uba85\ub839\uc5b4\ub97c \ud1b5\ud558\uc5ec OS \ub85c \uc811\uc18d\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. &nbsp; &nbsp; User \ubcc4\ub85c \uac01 \uba85\ub839\uc5b4\ub97c \uc218\ud589 \ud560 \uc218 \uc5c6\uac8c\ub054 \uc81c\uc57d\uc744 \ub458 \uc218\uac00 \uc788\ub294\ub370 \uc544\ub798\uc640 \uac19\uc740 Table\uc744 \uc774\uc6a9\ud558\uc5ec \uc81c\uc57d\uc744 \uc904 \uc218\uac00 \uc788\uc2b5\ub2c8\ub2e4. &nbsp; &nbsp; &nbsp; &nbsp; &#8212; SQL*PLUS [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":694,"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":[377,378,379,380,345,381],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile4.uf.252CDC4F56527A4C18329C.png?fit=1156%2C482","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/693"}],"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=693"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/693\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/694"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=693"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}