{"id":1124,"date":"2022-07-12T18:22:43","date_gmt":"2022-07-12T09:22:43","guid":{"rendered":"https:\/\/blog.opendocs.co.kr\/?p=1124"},"modified":"2022-07-12T18:23:20","modified_gmt":"2022-07-12T09:23:20","slug":"setting-tibero-%ea%b3%84%ec%a0%95%ec%83%9d%ec%84%b1-%eb%b0%8f-%ea%b6%8c%ed%95%9c%eb%b6%80%ec%97%ac","status":"publish","type":"post","link":"https:\/\/blog.opendocs.co.kr\/?p=1124","title":{"rendered":"[Setting | Tibero] \uacc4\uc815\uc0dd\uc131 \ubc0f \uad8c\ud55c\ubd80\uc5ec"},"content":{"rendered":"\n<p>Tibero \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uacc4\uc815\uc744 \uc0dd\uc131\ud558\uace0 \uad8c\ud55c\uc744 \ubd80\uc5ec\ud558\ub294 \ubc29\ubc95\uc744 \uc815\ub9ac\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\uc791\uc131\uc77c : 2022-07-12\nOS : Ubuntu 22.04 LTS\nTibero : 6.0<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>1> \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131 | \ucd94\uac00<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n# \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131\ncreate tablespace opendocs datafile '\/data\/tibero\/opendocs_tbl01.dbf' size 1000m autoextend on next 100m;\n# \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \ucd94\uac00\uc2dc\nalter tablespace opendocs add datafile '\/data\/tibero\/opendocs_tbl02.dbf' size 1000m autoextend on next 100m;\n<\/pre><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>2> \uc0ac\uc6a9\uc790 \uc0dd\uc131 | \uc0ad\uc81c (project \/ project_pw \uacc4\uc815)<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n# \uc0ac\uc6a9\uc790 \uc0dd\uc131\ncreate user project identified by &quot;project_pw&quot; default tablespace opendocs;\n# \uc0ac\uc6a9\uc790 \uc0ad\uc81c\ndrop user project cascade;\n<\/pre><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>3> \uc0ac\uc6a9\uc790 \uc811\uc18d \uad8c\ud55c\ubd80\uc5ec<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n# \uc811\uc18d\uad8c\ud55c\ngrant resource, connect to project;\n# select \uad8c\ud55c\ngrant select any table to project;\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nGRANT\u00a0DROP\u00a0USER\u00a0TO\u00a0EXAM;\nGRANT\u00a0LOCK\u00a0ANY\u00a0TABLE\u00a0TO\u00a0EXAM;\nGRANT\u00a0SELECT\u00a0ANY\u00a0TABLE\u00a0TO\u00a0EXAM;\nGRANT\u00a0INSERT\u00a0ANY\u00a0TABLE\u00a0TO\u00a0EXAM;\nGRANT\u00a0UPDATE\u00a0ANY\u00a0TABLE\u00a0TO\u00a0EXAM;\nGRANT\u00a0DELETE\u00a0ANY\u00a0TABLE\u00a0TO\u00a0EXAM;\nGRANT\u00a0SYSDBA\u00a0TO\u00a0EXAM;\nGRANT\u00a0CREATE\u00a0VIEW\u00a0TO\u00a0EXAM;\nGRANT\u00a0SELECT\u00a0ANY\u00a0SEQUENCE\u00a0TO\u00a0EXAM;\nGRANT\u00a0GRANT\u00a0ANY\u00a0ROLE\u00a0TO\u00a0EXAM;\nGRANT\u00a0EXECUTE\u00a0ANY\u00a0PROCEDURE\u00a0TO\u00a0EXAM; \nGRANT\u00a0DROP\u00a0ANY\u00a0TRIGGER\u00a0TO\u00a0EXAM; \nGRANT\u00a0GRANT\u00a0ANY\u00a0PRIVILEGE\u00a0TO\u00a0EXAM; \nGRANT\u00a0GRANT\u00a0ANY\u00a0OBJECT\u00a0PRIVILEGE\u00a0TO\u00a0EXAM; \nGRANT\u00a0EXECUTE\u00a0ANY\u00a0LIBRARY\u00a0TO\u00a0EXAM; \nGRANT\u00a0CREATE\u00a0ANY\u00a0TABLE\u00a0TO\u00a0EXAM;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Tibero \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uacc4\uc815\uc744 \uc0dd\uc131\ud558\uace0 \uad8c\ud55c\uc744 \ubd80\uc5ec\ud558\ub294 \ubc29\ubc95\uc744 \uc815\ub9ac\ud55c\ub2e4. \uc791\uc131\uc77c : 2022-07-12 OS : Ubuntu 22.04 LTS Tibero : 6.0 1> \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131 | \ucd94\uac00 2> \uc0ac\uc6a9\uc790 \uc0dd\uc131 | \uc0ad\uc81c (project \/ project_pw \uacc4\uc815) 3> \uc0ac\uc6a9\uc790 \uc811\uc18d \uad8c\ud55c\ubd80\uc5ec<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[270,271],"_links":{"self":[{"href":"https:\/\/blog.opendocs.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1124"}],"collection":[{"href":"https:\/\/blog.opendocs.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.opendocs.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.opendocs.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.opendocs.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1124"}],"version-history":[{"count":4,"href":"https:\/\/blog.opendocs.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1124\/revisions"}],"predecessor-version":[{"id":1129,"href":"https:\/\/blog.opendocs.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1124\/revisions\/1129"}],"wp:attachment":[{"href":"https:\/\/blog.opendocs.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.opendocs.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.opendocs.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}