{"id":1178,"date":"2016-01-03T10:05:43","date_gmt":"2016-01-03T10:05:43","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1178"},"modified":"2016-01-03T10:05:43","modified_gmt":"2016-01-03T10:05:43","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-%ec%8b%9c%eb%85%b8%eb%8b%98synonym","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1178","title":{"rendered":"\uc624\ub77c\ud074 \uc2dc\ub178\ub2d8(Synonym)"},"content":{"rendered":"

# Synonym <\/SPAN><\/P>
\n

\uc2dc\ub178\ub2d8\uc740 \uc624\ub77c\ud074 \uac1d\uccb4(\ud14c\uc774\ube14, \ubdf0, \uc2dc\ud000\uc2a4, \ud504\ub85c\uc2dc\uc800)\uc5d0 \ub300\ud55c \ub300\uccb4\uc774\ub984(Alias)\ub97c \ub9d0\ud569\ub2c8\ub2e4.  <\/SPAN><\/P>
\n

Synonym\uc740 \uc2e4\uc9c8\uc801\uc73c\ub85c \uadf8 \uc790\uccb4\uac00 Object\uac00 \uc544\ub2c8\ub77c Object\uc5d0 \ub300\ud55c \uc9c1\uc811\uc801\uc778 \ucc38\uc870 \uc785\ub2c8\ub2e4.
  <\/SPAN><\/P>
\n

\uc2dc\ub178\ub2d8 \uc0ac\uc6a9 \ub300\uc0c1
\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud22c\uba85\uc131\uc744 \uc81c\uacf5\ud558\uae30 \uc704\ud574\uc11c \uc0ac\uc6a9 \ud55c\ub2e4\uace0 \uc0dd\uac01\ud558\uba74 \ub429\ub2c8\ub2e4.   \uc2dc\ub178\ub2d8\uc740 \ub2e4\ub978 \uc720\uc800\uc758 \uac1d\uccb4\ub97c \ucc38\uc870\ud560 \ub54c \ub9ce\uc774 \uc0ac\uc6a9 \ud569\ub2c8\ub2e4.
\ub9cc\uc57d\uc5d0 \ub2e4\ub978 \uc720\uc800\uc758 \uac1d\uccb4\ub97c \ucc38\uc870\ud560 \uacbd\uc6b0\uac00 \uc788\uc744 \ub54c \uc2dc\ub178\ub2d8\uc744 \uc0dd\uc131\ud574\uc11c \uc0ac\uc6a9\uc744 \ud558\uba74\uc740   \ucd94\ud6c4\uc5d0 \ucc38\uc870\ud558\uace0 \uc788\ub294 \uc624\ud504\uc81d\ud2b8\uac00 \uc774\ub984\uc744 \ubc14\uafb8\uac70\ub098 \uc774\ub3d9\ud560 \uacbd\uc6b0 \uac1d\uccb4\ub97c \uc0ac\uc6a9\ud558\ub294 SQL\ubb38\uc744 \ubaa8\ub450    \ub2e4\uc2dc \uace0\uce58\ub294 \uac83\uc774 \uc544\ub2c8\ub77c \uc2dc\ub178\ub2d8\ub9cc \ub2e4\uc2dc \uc815\uc758\ud558\uba74 \ub418\uae30 \ub54c\ubb38\uc5d0 \ub9e4\uc6b0 \ud3b8\ub9ac \ud569\ub2c8\ub2e4. \uac1d\uccb4\uc758 \uae34 \uc774\ub984\uc744 \uc0ac\uc6a9\ud558\uae30 \ud3b8\ud55c \uc9e7\uc740 \uc774\ub984\uc73c\ub85c \ud574\uc11c  SQL\ucf54\ub529\uc744 \ub2e8\uc21c\ud654 \uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c \uac1d\uccb4\ub97c \ucc38\uc870\ud558\ub294 \uc0ac\uc6a9\uc790\uc758 \uc624\ube0c\uc81d\ud2b8\ub97c \uac10\ucd94 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 \uc774\uc5d0 \ub300\ud55c \ubcf4\uc548\uc744 \uc720\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.  \uc2dc\ub178\ub2d8\uc744 \uc0ac\uc6a9\ud558\ub294 \uc720\uc800\ub294 \ucc38\uc870\ud558\uace0 \uc788\ub294 \uac1d\uccb4\ub97c\uc5d0 \ub300\ud55c \uc0ac\uc6a9\uc790\uc758 object\uc758 \uc18c\uc720\uc790, \uc774\ub984, \uc11c\ubc84\uc774\ub984\uc744  \ubaa8\ub974\uace0 \uc2dc\ub178\ub2d8 \uc774\ub984\ub9cc \uc54c\uc544\ub3c4 \uc0ac\uc6a9 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/SPAN><\/P>
\n

   <\/P>
\n

# Synonym\uc744 \uc0ac\uc6a9\ud558\ub294 \uc774\uc720 <\/SPAN><\/P>
\n

\uc624\ube0c\uc81d\ud2b8\uc758 \uc2e4\uc81c \uc774\ub984\uacfc \uc18c\uc720\uc790 \uadf8\ub9ac\uace0 \uc704\uce58\ub97c \uac10\ucda4\uc73c\ub85c\uc368 database \ubcf4\uc548\uc744 \uac1c\uc120\ud558\ub294\ub370 \uc0ac\uc6a9 \ub429\ub2c8\ub2e4 <\/SPAN><\/P>
\n

Object\uc5d0\uc758 Public Access\ub97c \uc81c\uacf5 \ud569\ub2c8\ub2e4. <\/SPAN><\/P>
\n

Remote Database\uc758 Table, View, Program Unit\ub97c \uc704\ud574 \ud22c\uba85\uc131\uc744 \uc81c\uacf5 \ud569\ub2c8\ub2e4. <\/SPAN><\/P>
\n

Database \uc0ac\uc6a9\uc790\ub97c \uc704\ud574 SQL \ubb38\uc744 \ub2e8\uc21c\ud654 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/SPAN><\/P>
\n

   <\/P>
\n

# Synonym \uc885\ub958 <\/SPAN><\/P>
\n

\uc2dc\ub178\ub2d8\uc5d0\ub294 \ub450\uac00\uc9c0 \uc885\ub958\uac00 \uc788\uc2b5\ub2c8\ub2e4.  
Private Synonym  : \uc804\uc6a9 \uc2dc\ub178\ub2d8\uc740 \ud2b9\uc815 \uc0ac\uc6a9\uc790\ub9cc  \uc774\uc6a9\ud560\uc218 \uc788\uc2b5\ub2c8\ub2e4.
Public Synonym : \uacf5\uc6a9 \uc2dc\ub178\ub2d8\uc740 \uacf5\uc6a9 \uc0ac\uc6a9\uc790 \uadf8\ub8f9\uc774 \uc18c\uc720\ud558\uba70 \uadf8 Database\uc5d0 \uc788\ub294 \ubaa8\ub4e0 \uc0ac\uc6a9\uc790\uac00 \uacf5\uc720 \ud569\ub2c8\ub2e4. <\/SPAN><\/P>
\n

   <\/P>
\n

# Synonym \uc0dd\uc131 \ubb38\ubc95 <\/SPAN><\/P>
\n

scott USER\uc758 emp\ud14c\uc774\ube14\uc744 test USER\uac00 \uc0ac\uc6a9 \ud558\ub294 \uc608\uc81c. <\/SPAN><\/P>
\n

   <\/P>
\n

1. \uba3c\uc800 scott\/tiger USER\ub85c \uc811\uc18d\ud574\uc11c test USER\uc5d0\uac8c emp\ud14c\uc774\ube14\uc744 \uc870\uc791\ud560 \uad8c\ud55c\uc744 \ubd80\uc5ec\ud569\ub2c8\ub2e4. <\/SPAN><\/P>
\n

 <\/P>
\n

SQL>GRANT ALL ON emp TO test; <\/SPAN><\/P>
\n

\u00e8 test user\uc5d0 \ub300\ud558\uc5ec scott\uc758 emp\ud14c\uc774\ube14\uc744 \uc870\uc791\ud560 \uc218 \uc788\ub294 \uad8c\ud55c\uc744 \ubd80\uc5ec\ud569\ub2c8\ub2e4. <\/SPAN><\/P>
\n

   <\/P>
\n

2. test USER\ub85c \uc811\uc18d\ud574 \ub3d9\uc758\uc5b4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. <\/SPAN><\/P>
\n

SQL> connect test\/test <\/SPAN><\/P>
\n

SQL> CREATE SYNONYM scott_emp FOR scott.emp ; <\/SPAN><\/P>
\n

\u00e8 scott USER\uac00 \uc18c\uc720\ud558\uace0 \uc788\ub294 emp \ud14c\uc774\ube14\uc5d0 \ub300\ud574 scott_emp\ub77c\ub294 \uc77c\ubc18 \uc2dc\ub178\ub2d8\uc744 \uc0dd\uc131\ud588\uc2b5\ub2c8\ub2e4. <\/SPAN><\/P>
\n

scott \uc0ac\uc6a9\uc790\uc758 emp\ud14c\uc774\ube14\uc744 test \uc0ac\uc6a9\uc790\uac00 scitt_emp\ub77c\ub294 \ub3d9\uc758\uc5b4\ub85c \uc0ac\uc6a9 \ud569\ub2c8\ub2e4. . <\/SPAN><\/P>
\n

   <\/P>
\n

— \uc2dc\ub178\ub2d8\uc744 \uc774\uc6a9\ud55c \ucffc\ub9ac — \uc77c\ubc18 \ud14c\uc774\ube14\uc744 \ucffc\ub9ac <\/SPAN><\/P>
\n

SQL> SELECT empno, ename FROM scott_emp; SQL> SELECT empno, ename FROM scott.emp; <\/SPAN><\/P>
\n

\u00e8 \uc774 \ub450 \ucffc\ub9ac\uc758 \uacb0\uacfc\ub294 \uac19\uc2b5\ub2c8\ub2e4. <\/SPAN><\/P>
\n

   <\/P>
\n

\ub3d9\uc758\uc5b4 \uc0ad\uc81c \u00e8 SQL> DROP SYNONYM scott_emp <\/SPAN><\/P>
\n

   <\/P>
\n

   <\/P>
\n

  <\/SPAN> <\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

# Synonym \uc2dc\ub178\ub2d8\uc740 \uc624\ub77c\ud074 \uac1d\uccb4(\ud14c\uc774\ube14, \ubdf0, \uc2dc\ud000\uc2a4, \ud504\ub85c\uc2dc\uc800)\uc5d0 \ub300\ud55c \ub300\uccb4\uc774\ub984(Alias)\ub97c \ub9d0\ud569\ub2c8\ub2e4.  Synonym\uc740 \uc2e4\uc9c8\uc801\uc73c\ub85c \uadf8 \uc790\uccb4\uac00 Object\uac00 \uc544\ub2c8\ub77c Object\uc5d0 \ub300\ud55c \uc9c1\uc811\uc801\uc778 \ucc38\uc870 \uc785\ub2c8\ub2e4.   \uc2dc\ub178\ub2d8 \uc0ac\uc6a9 \ub300\uc0c1\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud22c\uba85\uc131\uc744 \uc81c\uacf5\ud558\uae30 \uc704\ud574\uc11c \uc0ac\uc6a9 \ud55c\ub2e4\uace0 \uc0dd\uac01\ud558\uba74 \ub429\ub2c8\ub2e4.   \uc2dc\ub178\ub2d8\uc740 \ub2e4\ub978 \uc720\uc800\uc758 \uac1d\uccb4\ub97c \ucc38\uc870\ud560 \ub54c \ub9ce\uc774 \uc0ac\uc6a9 \ud569\ub2c8\ub2e4. \ub9cc\uc57d\uc5d0 \ub2e4\ub978 \uc720\uc800\uc758 \uac1d\uccb4\ub97c \ucc38\uc870\ud560 \uacbd\uc6b0\uac00 \uc788\uc744 \ub54c \uc2dc\ub178\ub2d8\uc744 \uc0dd\uc131\ud574\uc11c \uc0ac\uc6a9\uc744 \ud558\uba74\uc740   \ucd94\ud6c4\uc5d0 \ucc38\uc870\ud558\uace0 \uc788\ub294 […]<\/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":[667,668],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1178"}],"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=1178"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1178\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1178"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}