{"id":434,"date":"2013-10-29T12:51:46","date_gmt":"2013-10-29T21:51:46","guid":{"rendered":"\/blog\/?p=434"},"modified":"2023-09-21T09:38:49","modified_gmt":"2023-09-21T00:38:49","slug":"oracle-%ec%82%ac%ec%9a%a9%ec%9e%90-%ea%b3%84%ec%a0%95-%ec%83%9d%ec%84%b1-%eb%b0%8f-%ea%b6%8c%ed%95%9c-%ec%84%a4%ec%a0%95","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=434","title":{"rendered":"Oracle \uc0ac\uc6a9\uc790 \uacc4\uc815 \uc0dd\uc131 \ubc0f \uad8c\ud55c \uc124\uc815"},"content":{"rendered":"\n

\ucd9c\ucc98 : http:\/\/urajilator.tistory.com\/1154<\/a><\/span>

1. \uc624\ub77c\ud074 \uc0ac\uc6a9\uc790 \uacc4\uc815 \uc0dd\uc131 \ubc29\ubc95<\/b><\/p>

  1) [\uae01\uc5b4\uc11c \uc0ac\uc6a9\ud558\ub294 \uc0d8\ud50c]<\/span><\/p>

- \uc0ac\uc6a9\uc790 \uacc4\uc815 \uc0dd\uc131 <\/p>

 \uad6c\ubd84<\/p><\/td>

 \ud544\uc218\uc5ec\ubd80<\/p><\/td>

 \uc0d8\ud50c \uac12<\/p><\/td><\/tr>

 \uc0ac\uc6a9\uc790 \uc774\ub984<\/span><\/td>

 \ud544\uc218<\/p><\/td>

 HWANGSANGGYU<\/p><\/td><\/tr>

 \ud328\uc2a4\uc6cc\ub4dc<\/span><\/td>

 \ud544\uc218<\/p><\/td>

 1<\/p><\/td><\/tr>

 \ub514\ud3f4\ud2b8 \uc811\uc18d \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4<\/p><\/td>

 <\/p><\/td>

 TS_SAMPLE<\/td><\/tr>

 \uc784\uc2dc\uc800\uc7a5 \uc0ac\uc6a9 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4<\/p><\/td>

 <\/p><\/td>

 TS_SAMPLE_TEMP<\/span><\/p><\/td><\/tr><\/tbody><\/table>


<\/p><\/span>
 
 CREATE USER HWANGSANGGYU     <\/b><\/span><\/span>
 IDENTIFIED BY \"123456\"<\/b>    
<\/div>
 DEFAULT TABLESPACE TS_SAMPLE<\/b> <\/div>
<\/td><\/tr><\/tbody><\/table>

- \uc0ac\uc6a9\uc790 \uacc4\uc815 \uc0ad\uc81c<\/p>

\uad6c\ubd84<\/p><\/td>

 \ud544\uc218\uc5ec\ubd80<\/p><\/td>

 \uc0d8\ud50c \uac12<\/p><\/td><\/tr>

 \uc0ac\uc6a9\uc790 \uc774\ub984<\/span><\/td>

 \ud544\uc218<\/p><\/td>

 HWANGSANGGYU<\/td><\/tr>

 \uad00\ub828 \uc2a4\ud0a4\ub9c8 \ub3d9\uc2dc \uc0ad\uc81c<\/p><\/td>

 <\/td>

  CASCADE<\/span><\/p><\/td><\/tr><\/tbody><\/table>
<\/span>

 <\/font>
 <\/font>DROP USER HWANGSANGGYU <\/font>CASCADE<\/font><\/span>

<\/p><\/td><\/tr><\/tbody><\/table><\/div>


<\/div>


<\/p>

2. \uc0ac\uc6a9\uc790\uc5d0\uac8c \uad8c\ud55c \uc124\uc815<\/b><\/p>

\uc0dd\uc131\ub41c \uc0ac\uc6a9\uc790\ub294 \uadf8\ub300\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4. <\/span><\/font><\/p>

\ud544\uc694\ud55c \uad8c\ud55c\uc744 \ud574\ub2f9 \uc0ac\uc6a9\uc790\uc5d0\uac8c \uc124\uc815\ud558\uc5ec\uc57c \ud55c\ub2e4.<\/span><\/font><\/p>


<\/span><\/font><\/p>

1) \uc8fc\uc694 \uad8c\ud55c \ubaa9\ub85d<\/span><\/font><\/p>

 \uad8c\ud55c\uba85<\/p><\/td>\n

 \uad8c\ud55c \ub0b4\uc6a9<\/p><\/td>\n<\/tr>\n

 CONNECT <\/span><\/td>\n

 ALTER SESSION, CREATE CLUSTER, CREATE DATABASE LINK, <\/span><\/p>

 CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM , <\/span><\/p>

 CREATE TABLE, CREATE VIEW<\/span><\/p><\/td>\n<\/tr>\n

 <\/span>RESOURC<\/span>E<\/span><\/span><\/td>\n

 <\/span>CREATE CLUSTER, CREATE PROCEDURE, <\/span>CREATE TRIGGER,<\/span><\/p>

 CREATE SEQUENCE, CREATE TABLE     <\/span>                             <\/span><\/p><\/td>\n<\/tr>\n

 <\/span>DBA<\/span> <\/span><\/span><\/td>\n

 \uc624\ub77c\ud074 DBAD\uc758<\/span> \ubaa8\ub4e0 \uc2dc\uc2a4\ud15c \uad8c\ud55c<\/span><\/p><\/td>\n<\/tr>\n

 <\/span>SELECT_CATELOG_ROLE<\/span><\/td>\n <\/span>\ubaa8\ub4e0 \ud14c\uc774\ube14\uacfc \ubdf0\uc5d0 \ub300\ud55c \uc870\ud68c \uad8c\ud55c<\/span><\/td>\n<\/tr>\n
 DELETE_CATELOG_ROLE <\/span><\/td> \ubaa8\ub4e0 \ud328\ud0a4\uc9c0\uc5d0 \ub300\ud55c \uc0ad\uc81c \uad8c\ud55c  <\/span><\/td><\/tr>
 EXECURE_CATELOG_ROLE<\/span><\/td> \ubaa8\ub4e0 \ud328\ud0a4\uc9c0\uc5d0 \ub300\ud55c \uc2e4\ud589 \uad8c\ud55c  <\/span><\/td><\/tr><\/tbody><\/table>

  <\/span><\/p>

<\/span>

 <\/font><\/p>

 GRANT <\/font>CONNECT  TO<\/span> <\/span> HWANGSANGGYU;<\/font><\/span><\/p>

 GRANT <\/font>RESOURCE TO<\/span> <\/span> <\/span>HWANGSANGGYU;<\/font><\/span><\/p>


<\/b><\/span><\/font><\/p>

 <\/b><\/span><\/font>\ub610\ub294 <\/span><\/p>


<\/span><\/font><\/span> GRANT <\/font>CONNECT<\/span> , <\/span>RESOURCE TO<\/span> <\/span> HWANGSANGGYU;<\/font><\/span><\/p>


<\/p><\/td><\/tr><\/tbody><\/table><\/div>

 
<\/span><\/font><\/p>\n","protected":false},"excerpt":{"rendered":"

\ucd9c\ucc98 : http:\/\/urajilator.tistory.com\/1154 1. \uc624\ub77c\ud074 \uc0ac\uc6a9\uc790 \uacc4\uc815 \uc0dd\uc131 \ubc29\ubc95   1) [\uae01\uc5b4\uc11c \uc0ac\uc6a9\ud558\ub294 \uc0d8\ud50c] – \uc0ac\uc6a9\uc790 \uacc4\uc815 \uc0dd\uc131   \uad6c\ubd84  \ud544\uc218\uc5ec\ubd80  \uc0d8\ud50c \uac12  \uc0ac\uc6a9\uc790 \uc774\ub984  \ud544\uc218  HWANGSANGGYU  \ud328\uc2a4\uc6cc\ub4dc  \ud544\uc218  1  \ub514\ud3f4\ud2b8 \uc811\uc18d \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4    TS_SAMPLE  \uc784\uc2dc\uc800\uc7a5 \uc0ac\uc6a9 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4    TS_SAMPLE_TEMP   CREATE USER HWANGSANGGYU       IDENTIFIED BY “123456”      DEFAULT TABLESPACE TS_SAMPLE  – \uc0ac\uc6a9\uc790 \uacc4\uc815 \uc0ad\uc81c \uad6c\ubd84 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-434","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/434","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=434"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/434\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}