SQL - PostgreSQL, DCL(Data Control Language)
ยท
๐Ÿงฉ SQL
โœ… DCL(Data Control Language)DDL: Data Definition LanguageDML: Data Manipulation LanguageTCL: Transaction Control LanguageDCL: ์‚ฌ์šฉ์ž๊ฐ€ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ์กฐํšŒํ•˜๊ณ  ์ˆ˜์ •ํ•  ์ˆ˜ ์žˆ๋Š” ๊ถŒํ•œ์„ ์„ค์ •ํ•  ์ˆ˜ ์žˆ๊ฒŒ ํ•ด์ฃผ๋Š” ์–ธ์–ด role ์ƒ์„ฑCREATE ROLE marketerWITH login PASSWORD 'marketing4ever';๋น„๋ฐ€๋ฒˆํ˜ธ OCREATE ROLE editor;๋น„๋ฐ€๋ฒˆํ˜ธ X role์— ๊ถŒํ•œ ๋ถ€์—ฌGRANT SELECT ON movies TO marketer;์ฝ๊ธฐ ๊ถŒํ•œ๋งŒ ์žˆ์Œ GRANTSELECT,UPDATE,INSERT ON movies TO marketer;GRANTSELECT, INSERT ON st..

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”