Search

DCL(Data Control Language)

ํƒœ๊ทธ
SQL
DCL
๋ฉ€ํ‹ฐ์บ ํผ์Šค
DCL
[๊ถŒํ•œ๊ด€๋ฆฌ]
๊ด€๋ฆฌ์ž ๊ณ„์ •
โ€ข
๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๊ด€๋ฆฌ๋ฅผ ๋‹ด๋‹นํ•˜๋Š” ์Šˆํผ ์‚ฌ์šฉ์ž
โ€ข
๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์˜ ๋ชจ๋“  ๊ถŒํ™˜๊ณผ ์ฑ…์ž„์„ ๊ฐ€์ง€๊ณ  ์žˆ๋‹ค. (root)
์‚ฌ์šฉ์ž ๊ณ„์ •
โ€ข
๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์—์„œ ๋ณธ์ธ์ด ๋งก์€ ์ž‘์—…์„ ์ˆ˜ํ–‰ํ•˜๋Š” ๊ณ„์ •
โ€ข
์‚ฌ์šฉ์ž ๊ณ„์ •์€ ์—…๋ฌด์— ํ•„์š”ํ•œ ์ตœ์†Œํ•œ์˜ ๊ถŒํ•œ๋งŒ ๋ถ€์—ฌํ•œ๋‹ค.
๊ตฌ๋ฌธ
โ€ข
๊ณ„์ •์ƒ์„ฑ
CREATE USER [๊ณ„์ •๋ช…] IDENTIFIED BY โ€˜๋น„๋ฒˆโ€™;
SHOW GRANTS FOR [๊ณ„์ •๋ช…];
โ€ข
GRANT [๊ถŒํ•œ] ON [DB ์ด๋ฆ„].[ํ…Œ์ด๋ธ”๋ช…] TO [๊ณ„์ •๋ช…];
โ€ข
WITH GRANT OPTION : ๋ถ€์—ฌ๋ฐ›์€ ๊ถŒํ•œ์„ ๋‹ค๋ฅธ ์‚ฌ์šฉ์ž์—๊ฒŒ ๋ถ€์—ฌํ•  ๊ถŒํ•œ์„ ์ฃผ๋Š” ์˜ต์…˜
โ€ข
ROLE : ์—ญํ• ์— ํ•„์š”ํ•œ ๊ถŒํ•œ์„ ํ•˜๋‚˜๋กœ ๋ฌถ๋Š” ๊ฒƒ
CREATE ROLE [๊ถŒํ•œ ์ด๋ฆ„];
GRANT [๊ถŒํ•œ1], [๊ถŒํ•œ2] .. ON [DB ์ด๋ฆ„].[ํ…Œ์ด๋ธ”๋ช…] TO [๊ถŒํ•œ์ด๋ฆ„];
โ€ข
๊ถŒํ•œ ํšŒ์ˆ˜
REVOKE [๊ถŒํ•œ] ON [DB ์ด๋ฆ„].[ํ…Œ์ด๋ธ”๋ช…] FROM [๊ณ„์ •๋ช…/๊ถŒํ•œ์ด๋ฆ„];