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

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

์„œ๋ฒ„ ์ ‘๊ทผ ๊ถŒํ•œ์„ ์ง์ ‘ ๋ถ€์—ฌํ•˜๋Š” ๋ฐฉ๋ฒ•

์„œ๋ฒ„ ์ ‘๊ทผ ๊ถŒํ•œ์„ ์ง์ ‘ ๋ถ€์—ฌํ•˜๋Š” ๋ฐฉ๋ฒ•

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

์„œ๋ฒ„ ์ ‘๊ทผ ๊ถŒํ•œ์„ ์ง์ ‘ ๋ถ€์—ฌํ•˜๋Š” ๋ฐฉ๋ฒ•

Overview

๊ด€๋ฆฌ์ž๋Š” ์„œ๋ฒ„์— ์‚ฌ์šฉ ๋ถˆ๊ฐ€๋Šฅํ•œ ๋ช…๋ น์–ด ํ…œํ”Œ๋ฆฟ์„ ๊ด€๋ฆฌํ•  ์ˆ˜ ์žˆ์œผ๋ฉฐ, ์„œ๋ฒ„์— ๋Œ€ํ•œ ์ ‘๊ทผ ๊ถŒํ•œ(Permission)์„ ์ง์ ‘ ๋ถ€์—ฌํ•˜๊ฑฐ๋‚˜ ํšŒ์ˆ˜ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ๋ช…๋ น์–ด ์ฐจ๋‹จ์€ string ๊ธฐ๋ฐ˜์œผ๋กœ ์ด๋ฃจ์–ด์ง€๋ฉฐ, ์ •๊ทœ์‹์„ ํ†ตํ•œ ๋ช…๋ น์–ด ์ฐจ๋‹จ๋„ ์ง€์›ํ•˜๊ณ  ์žˆ์Šต๋‹ˆ๋‹ค.

๋ช…๋ น์–ด ํ…œํ”Œ๋ฆฟ ์„ค์ •ํ•˜๊ธฐ

STEP 1 Command Templates ๋ฉ”๋‰ด์—์„œ Create Template ๋ฒ„ํŠผ์„ ํด๋ฆญํ•˜์—ฌ ๋‹ค์Œ ์ •๋ณด๋ฅผ ์ž…๋ ฅํ•ฉ๋‹ˆ๋‹ค.

  • Name: ํ…œํ”Œ๋ฆฟ์„ ๊ตฌ๋ณ„ํ•  ์ˆ˜ ์žˆ๋Š” ์ด๋ฆ„
  • Description: ํ•ด๋‹น ํ…œํ”Œ๋ฆฟ์— ๋Œ€ํ•œ ์ƒ์„ธ ์ •๋ณด

STEP 2 Base Type์—์„œ ํ…œํ”Œ๋ฆฟ์— ๋“ฑ๋ก๋œ ๋ช…๋ น์–ด์˜ ํ—ˆ์šฉ, ๊ธˆ์ง€ ์—ฌ๋ถ€๋ฅผ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.

  • Deny: ๊ธˆ์ง€ํ•  ๋ช…๋ น์–ด๋ฅผ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค. ์„ค์ •๋œ ๋ช…๋ น์–ด ์™ธ ๋‹ค๋ฅธ ๋ช…๋ น์–ด๋Š” ์‚ฌ์šฉ์ด ๊ฐ€๋Šฅํ•ฉ๋‹ˆ๋‹ค.
  • Allow: ํ—ˆ์šฉํ•  ๋ช…๋ น์–ด๋ฅผ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค. ์„ค์ •๋œ ๋ช…๋ น์–ด ์™ธ ๋‹ค๋ฅธ ๋ช…๋ น์–ด๋Š” ์‚ฌ์šฉ์ด ๋ถˆ๊ฐ€๋Šฅํ•ฉ๋‹ˆ๋‹ค.

STEP 3 **Commands(SSH)**์—์„œ ์„œ๋ฒ„์—์„œ ํ„ฐ๋ฏธ๋„์„ ํ†ตํ•ด ์‹คํ–‰๋˜๋Š” ๋ช…๋ น์–ด ์ •์ฑ…์„ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค.

  • Keyword: ๋ช…๋ น์–ด๋ฅผ ํ‚ค์›Œ๋“œ๋กœ ์ž…๋ ฅํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.
  • RegEx: ๋ช…๋ น์–ด๋ฅผ ์ •๊ทœ ํ‘œํ˜„์‹ ํ˜•ํƒœ๋กœ ์ž…๋ ฅํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

STEP 4 **Commands(SFTP)**์—์„œ ์›น SFTP, FTP๋ฅผ ํ†ตํ•ด ์‹คํ–‰๋˜๋Š” ๊ธฐ๋Šฅ ์ •์ฑ…์„ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค.

STEP 5 ์šฐ์ธก ํ•˜๋‹จ์˜ Save ๋ฒ„ํŠผ์„ ํด๋ฆญํ•˜์—ฌ ํ…œํ”Œ๋ฆฟ์„ ์ €์žฅํ•ฉ๋‹ˆ๋‹ค.

์„œ๋ฒ„ ๋˜๋Š” ์„œ๋ฒ„๊ทธ๋ฃน์— ๋Œ€ํ•œ ๊ถŒํ•œ์„ ์ง์ ‘ ๋ถ€์—ฌํ•˜๊ธฐ

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

STEP 2 Grant Permissions ๋ฒ„ํŠผ์„ ํด๋ฆญํ•ฉ๋‹ˆ๋‹ค.

STEP 3 ์™ผ์ชฝ ๋ชฉ๋ก์—์„œ ์ ‘๊ทผ ๊ถŒํ•œ์„ ๋ถ€์—ฌํ•  ์„œ๋ฒ„ ๊ทธ๋ฃน์„ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.

STEP 4 ์„ ํƒํ•œ ์„œ๋ฒ„ ๊ทธ๋ฃน์— ์†ํ•œ ์„œ๋ฒ„ ๋ฐ ๊ณ„์ •์ด ์˜ค๋ฅธ์ชฝ์— ํ‘œ์‹œ๋ฉ๋‹ˆ๋‹ค. ๋ชฉ๋ก์—์„œ ๊ถŒํ•œ์„ ๋ถ€์—ฌํ•  ์„œ๋ฒ„์™€ ๊ณ„์ •์„ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.

  1. ์šฐ์ธก์—์„œ Servers์—์„œ ๊ถŒํ•œ์„ ๋ถ€์—ฌํ•  ์„œ๋ฒ„๋ฅผ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.
  2. ์šฐ์ธก ํ•˜๋‹จ Accounts์—์„œ ์„ ํƒ๋œ ์„œ๋ฒ„์— ์ ‘์†ํ•  ์ˆ˜ ์žˆ๋Š” ๊ณ„์ •์„ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.

STEP 5 Next ๋ฒ„ํŠผ์„ ํด๋ฆญํ•ฉ๋‹ˆ๋‹ค.

STEP 6 ๋‹ค์Œ ์ •์ฑ…์„ ์„ค์ •ํ•˜๊ณ  Grant ๋ฒ„ํŠผ์„ ๋ˆŒ๋Ÿฌ ์ตœ์ข…์ ์œผ๋กœ ๊ถŒํ•œ์„ ๋ถ€์—ฌํ•ฉ๋‹ˆ๋‹ค.

  • Expiration Date: ์ ‘์† ๊ถŒํ•œ ๋งŒ๋ฃŒ์ผ์„ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค. ์ตœ๋Œ€ 1๋…„๊นŒ์ง€ ์„ค์ •ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. (Default = 1๋…„ ํ›„)
  • Protocols: ์„œ๋ฒ„ ์ ‘์†์— ์‚ฌ์šฉํ•  ํ”„๋กœํ† ์ฝœ์„ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.
  • Command Template: ์„œ๋ฒ„์— ์ ‘์† ํ›„ ์‚ฌ์šฉ ๋ถˆ๊ฐ€๋Šฅํ•œ ๋ช…๋ น ์„ธํŠธ๋ฅผ ์„ค์ •ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ํ•˜๋‹จ์˜ Command Template Details์„ ํด๋ฆญํ•˜์—ฌ ์„ค์ •๋œ ์„ธ๋ถ€ ์กฐ๊ฑด์„ ํ™•์ธํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.
  • Access Start Time: ์ ‘์† ๊ฐ€๋Šฅ ์‹œ์ž‘ ์‹œ๊ฐ„์„ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค.
  • Access End Time: ์ ‘์† ๊ฐ€๋Šฅ ์ข…๋ฃŒ ์‹œ๊ฐ„์„ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค.
  • Access Weekday: ์ ‘์†์„ ํ—ˆ์šฉํ•˜๋Š” ์š”์ผ์„ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค.
  • IP Addresses: ์ ‘์†์„ ํ—ˆ์šฉํ•˜๋Š” IP ์ฃผ์†Œ๋ฅผ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค.
  • Command Audit: ์ด Permission์„ ํ†ตํ•ด ์—ฐ๊ฒฐ๋œ ์„ธ์…˜์—์„œ ์‚ฌ์šฉ๋œ ์ปค๋งจ๋“œ์˜ ๋กœ๊น… ์—ฌ๋ถ€๋ฅผ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค.
  • Command Detection: Script ๋ฐ Alias๊ฐ€ ํ˜ธ์ถœ๋  ๋•Œ, ๋‚ด๋ถ€์˜ ๊ธˆ์ง€ ๋ช…๋ น์–ด ํƒ์ง€ ์—ฌ๋ถ€๋ฅผ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค.
  • Proxy Usage: QueryPie Agent์—์„œ ์ด Permission์„ ํ†ตํ•ด ์„œ๋ฒ„ ์ ‘์† ๊ฐ€๋Šฅ ์—ฌ๋ถ€๋ฅผ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค.
  • Max Sessions: ํ•œ ์œ ์ €๊ฐ€ ํ•œ ์„œ๋ฒ„์— ๋™์‹œ ์—ฐ๊ฒฐ ๊ฐ€๋Šฅํ•œ ์„ธ์…˜ ์ˆ˜๋ฅผ ์ œํ•œํ•ฉ๋‹ˆ๋‹ค.
  • Session Timeout (minutes): ์ž…๋ ฅ๋œ ์‹œ๊ฐ„(๋ถ„) ๋งŒํผ ํ™œ๋™ํ•˜์ง€ ์•Š์œผ๋ฉด ์„ธ์…˜์€ ์ข…๋ฃŒ๋ฉ๋‹ˆ๋‹ค.
์„œ๋ฒ„ ์ ‘๊ทผ ๊ถŒํ•œ์„ ์ง์ ‘ ๋ถ€์—ฌํ•˜๋Š” ๋ฐฉ๋ฒ• | QueryPie