{"id":1171,"date":"2016-01-03T10:03:31","date_gmt":"2016-01-03T10:03:31","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1171"},"modified":"2016-01-03T10:03:31","modified_gmt":"2016-01-03T10:03:31","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-%eb%b3%b4%ec%95%88","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1171","title":{"rendered":"\uc624\ub77c\ud074 \ubcf4\uc548"},"content":{"rendered":"<p><P style=\"MARGIN-LEFT: 20pt\"><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uad8c\ud55c <\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">(Privilege)<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\"><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">GRANT privilege <\/SPAN><\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\"><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: Arial\">ON object<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\u3141 <\/SPAN><\/SPAN><\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\"><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">TO [user, role, PUBLIC] <\/SPAN><\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\"><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">[WITH GRANT OPTION] <\/SPAN><\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\"><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">SQL&gt; CONN system <\/SPAN><\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\"><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">SQL&gt; GRANT CREATE SESSION TO ora10g; <\/SPAN><\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\">&nbsp; &nbsp;<\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\"><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">ROLE <\/SPAN><\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\"><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">GRANT privilege01, privilege02, .. TO role_name; <\/SPAN><\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\"><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">SQL&gt; GRANT CREATE SESSION, SELECT ANY TABLE TO select_table; <\/SPAN><\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\"><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">SQL&gt; GRANT select_table TO ora10g; <\/SPAN><\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\"><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">role.sql <\/SPAN><\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\"><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: Arial\"><\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc0ac\uc6a9\uc790\uc758 <\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">Role <\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ubc0f <\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">Privilege <\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc815\ubcf4\ub97c \ud655\uc778\ud558\ub294 \uc2a4\ud06c\ub9bd\ud2b8<\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">.<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\"><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc800\uc7a5 \uc601\uc5ed \ubc0f <\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">Quota <\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc124\uc815 <\/SPAN><\/SPAN><\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\"><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">SQL&gt; ALTER USER ora10g <\/SPAN><\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\"><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">QUOTA 10M ON tablespace_name; <\/SPAN><\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\">&nbsp; &nbsp;<\/P><br \/>\n<P style=\"MARGIN-LEFT: 20pt\"><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\uc0ac\uc6a9\uc790 \uc790\uc6d0 \ubc0f \ud504\ub85c\ud30c\uc77c \uc124\uc815 <\/SPAN><\/P><br \/>\n<UL><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: Arial\">Profile <\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc815\ubcf4 \ud655\uc778 <\/SPAN><\/SPAN><\/DIV><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">SQL&gt; SELECT profile, resource_name, limit <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">FROM dba_profiles <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">WHERE PROFILE = &#8216;profile_name&#8217;; <\/SPAN><\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: Arial\">Profile<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc744 \uc774\uc6a9\ud55c \uc2dc\uc2a4\ud15c \uc790\uc6d0 \uad00\ub9ac <\/SPAN><\/SPAN><\/DIV><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: Arial\">a. Profile<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc744 \ud65c\uc131\ud654 \ud55c\ub2e4<\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">.<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: Arial\">b. Profile<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc744 \uc0dd\uc131\ud558\uba74\uc11c \uc81c\ud55c\ud558\uace0\uc790 \ud558\ub294 \uc790\uc6d0\uc744 \uc815\uc758\ud55c\ub2e4<\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">.<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: Arial\">c. <\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc0dd\uc131\ub41c <\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">profile<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc744 \uc0ac\uc6a9\uc790\uc5d0\uac8c \ubd80\uc5ec\ud55c\ub2e4<\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">.<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\uc99d <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: Arial\">a.<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc811\uc18d \uc2dc \ud328\uc2a4\uc6cc\ub4dc \uc554\ud638\ud654 <\/SPAN><\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: Arial\">&#8211; <\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ub124\ud2b8\uc6cc\ud06c\ub97c \uc774\uc6a9\ud55c \uc6d0\uaca9 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uc18d \uc2dc \uc554\ud638\ud654\ub41c \ud328\uc2a4\uc6cc\ub4dc \uc0ac\uc6a9<\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">.<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: Arial\">b.<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uacc4\uc815 \uc7a0\uae08 <\/SPAN><\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">SQL&gt; CREATE PROFILE limit_login LIMIT <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">FAILED_LOGIN_ATTEMPTS 3 <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">PASSWORD_LOCK_TIME unlimited; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">SQL&gt; ALTER USER ora10g PROFILE limit_login; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: Arial\">c.<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ud328\uc2a4\uc6cc\ub4dc <\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">lifetime<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uacfc \ud3d0\uae30 <\/SPAN><\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">SQL&gt; ALTER PROFILE limit_login LIMIT <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">PASSWORD_LIFE_TIME 180; <\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">SQL&gt; ALTER USER ora10g PROFILE limit_login; <\/SPAN><\/P><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: Arial\">d. <\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ud328\uc2a4\uc6cc\ub4dc \ubcf5\ud569 \uac80\uc99d <\/SPAN><\/SPAN><\/P><\/LI><br \/>\n<LI><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ucd5c\uc18c <\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">4<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ubb38\uc790 \uc774\uc0c1\uc758 \uae38\uc774\ub97c \uac00\uc838\uc57c \ud55c\ub2e4<\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">.<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc0ac\uc6a9\uc790 <\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">ID<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc640 \uac19\uc9c0 \uc54a\uc544\uc57c \ud55c\ub2e4<\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">.<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ucd5c\uc18c\ud55c \ud55c \ubb38\uc790\uc640 \uc22b\uc790 \uadf8\ub9ac\uace0 \uad6c\ub450\uc810\uc744 \ud3ec\ud568\ud55c\ub2e4<\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">.<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ub2e8\uc21c\ud55c \ub2e8\uc5b4\uc640 \uc77c\uce58\ud558\uc9c0 \uc54a\ub3c4\ub85d \ud55c\ub2e4<\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">. <\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc608\ub97c \ub4e4\uba74 <\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">ACCOUNT, USER <\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ub4f1\uc744 \ud5c8\ub77d\ud558\uc9c0 \uc54a\ub294\ub2e4<\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">.<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ubcc0\uacbd \uc804\uc758 \ud328\uc2a4\uc6cc\ub4dc\uc640 \ucd5c\uc18c <\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">3<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ubb38\uc790\uac00 \ub2ec\ub77c\uc57c \ud55c\ub2e4<\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">.<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; COLOR: black\"><SPAN style=\"FONT-FAMILY: Arial\">&#8211; <\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\ud568\uc218 <\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">VERIFY_FUNCTION<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc744 \uc0dd\uc131\ud558\uace0<\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">, DEFAULT PROFILE<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\">\uc5d0 \uc774\ub97c \uc801\uc6a9\ud55c\ub2e4<\/SPAN><SPAN style=\"FONT-FAMILY: Arial\">.<\/SPAN><SPAN style=\"FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: black\">&nbsp; <\/SPAN>&nbsp;<\/P><\/LI><\/UL><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uad8c\ud55c (Privilege) GRANT privilege ON object\u3141 TO [user, role, PUBLIC] [WITH GRANT OPTION] SQL&gt; CONN system SQL&gt; GRANT CREATE SESSION TO ora10g; &nbsp; &nbsp; ROLE GRANT privilege01, privilege02, .. TO role_name; SQL&gt; GRANT CREATE SESSION, SELECT ANY TABLE TO select_table; SQL&gt; GRANT select_table TO ora10g; role.sql \uc0ac\uc6a9\uc790\uc758 Role \ubc0f Privilege \uc815\ubcf4\ub97c \ud655\uc778\ud558\ub294 \uc2a4\ud06c\ub9bd\ud2b8. \uc800\uc7a5 \uc601\uc5ed [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[9],"tags":[660,335],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1171"}],"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=1171"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1171\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1171"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}