songining
๊ณผ๋ชฉII SQL ๊ธฐ๋ณธ ๋ฐ ํ™œ์šฉ 2์žฅ - 7์ ˆ DCL
SQLD 2021. 5. 25. 22:37

DCL - ์œ ์ €๋ฅผ ์ƒ์„ฑํ•˜๊ณ  ๊ถŒํ•œ์„ ์ œ์–ดํ•  ์ˆ˜ ์žˆ๋Š” DCL ๋ช…๋ น์–ด๊ฐ€ ์žˆ๋‹ค. ์‹œ์Šคํ…œ ๊ถŒํ•œ - ORACLE์˜ DBA ๊ถŒํ•œ์„ ๊ฐ€์ง€๊ณ  ์žˆ๋Š” SYSTEM ์œ ์ €๋กœ ์ ‘์†ํ•˜๋ฉด ์œ ์ € ์ƒ์„ฑ๊ถŒํ•œ์„ ๋‹ค๋ฅธ ์œ ์ €์—๊ฒŒ ๋ถ€์—ฌํ•  ์ˆ˜ ์žˆ๋‹ค. CONN SYSTEM/MANAGER -> ์—ฐ๊ฒฐ๋˜์—ˆ๋‹ค. GRANT CREATE USER TO SCOTT; -> SCOTT์—๊ฒŒ ์œ ์ € ์ƒ์„ฑ ๊ถŒํ•œ ๋ถ€์—ฌ CONN SCOTT/TIGER -> ์—ฐ๊ฒฐ๋˜์—ˆ๋‹ค. CREATE USER PJS IDENTIFIED BY KOREA7; -> KOREA7 ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ ๊ฐ€์ง„ ์œ ์ € PJS ์ƒ์„ฑ SESSION ์ƒ์„ฑ ๊ถŒํ•œ - ์œ ์ €๊ฐ€ ๋กœ๊ทธ์ธ์„ ํ•˜๊ธฐ ์œ„ํ•ด์„œ๋Š” CREATE SESSION ๊ถŒํ•œ์„ ๋ถ€์—ฌ๋ฐ›์•„์•ผ ํ•œ๋‹ค. CONN SYSTESM/MANAGER GRANT CREATE SESSION TO ..