QueryPie Community Edition is live ๐ŸŽ‰ Get it now for free Download today!

๋ฌด๋ฃŒ๋กœ ์‹œ์ž‘ํ•˜๊ธฐ
ACP ๊ธฐ๋Šฅ

๊ถŒํ•œ ์ƒ์„ฑ ๋ฐ ๋ถ€์—ฌ ๋ฐฉ๋ฒ•

๊ถŒํ•œ ์ƒ์„ฑ ๋ฐ ๋ถ€์—ฌ ๋ฐฉ๋ฒ•

2024๋…„ 11์›” 29์ผ

๊ถŒํ•œ ์ƒ์„ฑ ๋ฐ ๋ถ€์—ฌ ๋ฐฉ๋ฒ•

Overview

๋†’์€ ์ˆ˜์ค€์œผ๋กœ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ ‘๊ทผ ๋ฐ ๋ณด์•ˆ์„ ๊ด€๋ฆฌํ•˜๊ธฐ ์œ„ํ•ด ์—ญํ• ๊ณผ ์†์„ฑ์„ ๊ธฐ๋ฐ˜์œผ๋กœ ํ•œ ๋‹ค์–‘ํ•œ ํ˜•ํƒœ์˜ ์•ก์„ธ์Šค ์ œ์–ด๋ฅผ ์ œ๊ณตํ•ฉ๋‹ˆ๋‹ค. ์ธ์ฆ๋œ ์‚ฌ์šฉ์ž์— ํ•œํ•ด QueryPie๋ฅผ ํ†ตํ•ด ์ ‘๊ทผ ๊ถŒํ•œ์ด ๋ถ€์—ฌ๋œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์—๋งŒ ์•ก์„ธ์Šคํ•  ์ˆ˜ ์žˆ์œผ๋ฉฐ SQL ์‹คํ–‰์€ ๋ฏธ๋ฆฌ ์ •์˜๋œ SQL ๊ตฌ๋ฌธ ์กฐํ•ฉ์„ ๊ธฐ๋ฐ˜์œผ๋กœ ์‹คํ–‰์ด ์ œํ•œ๋ฉ๋‹ˆ๋‹ค.

Granting Access Control Privileges

STEP 1 Privilege ๋ฉ”๋‰ด์—์„œ Create Privilege Type ๋ฒ„ํŠผ์„ ๋ˆŒ๋Ÿฌ ๊ถŒํ•œ์„ ์ƒ์„ฑํ•ฉ๋‹ˆ๋‹ค.

  • Name: Privilege๋ฅผ ๊ตฌ๋ถ„ํ•  ์ˆ˜ ์žˆ๋Š” ์ด๋ฆ„
  • Database Type: ๊ตฌ๋ฌธ ์†์„ฑ์— ๋”ฐ๋ผ General, Redis๋กœ ๊ตฌ๋ถ„๋ฉ๋‹ˆ๋‹ค.
  • Privilege Type: ํ•ด๋‹น ๊ถŒํ•œ์œผ๋กœ ์‹คํ–‰์„ ํ—ˆ์šฉํ•  ๊ตฌ๋ฌธ์„ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.
  • Functions: ํ•ด๋‹น ๊ถŒํ•œ์œผ๋กœ ํ—ˆ์šฉ ๊ฐ€๋Šฅํ•œ ์ž‘์—…์„ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.
    • QueryPie Web Editor ๋‚ด์—์„œ์˜ ๊ธฐ๋Šฅ์„ ์ œ์–ดํ•ฉ๋‹ˆ๋‹ค.

STEP 2 Access Control ๋ฉ”๋‰ด์—์„œ ๊ถŒํ•œ์„ ๋ถ€์—ฌํ•  ์‚ฌ์šฉ์ž ํ˜น์€ ๊ทธ๋ฃน์„ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.

STEP 3 ๊ถŒํ•œ์„ ๋ถ€์—ฌํ•  ๋Œ€์ƒ ์ปค๋„ฅ์…˜์„ ์ฐพ๊ณ  Privilege๋ฅผ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.

๊ถŒํ•œ ์ƒ์„ฑ ๋ฐ ๋ถ€์—ฌ ๋ฐฉ๋ฒ• | QueryPie