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

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

์‹œ์Šคํ…œ ์˜์—ญ์˜ ๊ฐ์‚ฌ ๋กœ๊ทธ๋ฅผ ํ™•์ธํ•˜๋Š” ๋ฐฉ๋ฒ•

์‹œ์Šคํ…œ ์˜์—ญ์˜ ๊ฐ์‚ฌ ๋กœ๊ทธ๋ฅผ ํ™•์ธํ•˜๋Š” ๋ฐฉ๋ฒ•

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

์‹œ์Šคํ…œ ์˜์—ญ์˜ ๊ฐ์‚ฌ ๋กœ๊ทธ๋ฅผ ํ™•์ธํ•˜๋Š” ๋ฐฉ๋ฒ•

Overview

QueryPie์˜ System Access Control์—์„œ ๋ฐœ์ƒํ•˜๋Š” ๋กœ๊ทธ๋“ค์„ ์„œ๋ฒ„ ๋กœ๊ทธ ์˜์—ญ์—์„œ ํ™•์ธํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์„œ๋ฒ„ ์ ‘์† ๊ถŒํ•œ ๋ถ€์—ฌ์™€ ํšŒ์ˆ˜, ์„œ๋ฒ„ ๋กœ๊ทธ์ธ/๋กœ๊ทธ์•„์›ƒ, ์ˆ˜ํ–‰ํ•œ ๋ช…๋ น์–ด ์ด๋ ฅ ๋“ฑ์˜ ์ •๋ณด๋ฅผ ํ™•์ธํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ๊ทธ ์™ธ, QueryPie๋ฅผ ํ†ตํ•ด ์ ‘์†ํ•œ ์„ธ์…˜ ๋ฆฌ์ŠคํŠธ์„ ์กฐํšŒํ•˜๊ฑฐ๋‚˜ ์„ธ์…˜์„ ๊ฐ•์ œ์ข…๋ฃŒ ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

QueryPie SAC์—์„œ ์ œ๊ณตํ•˜๋Š” ๋กœ๊ทธ

Server Access History

  • ์„œ๋ฒ„ ์—ฐ๊ฒฐ ๋ฐ ์—ฐ๊ฒฐํ•ด์ œ ์ด๋ ฅ์„ ๊ธฐ๋กํ•ฉ๋‹ˆ๋‹ค.

Command Audit

  • QueryPie๋ฅผ ํ†ตํ•ด ์ ‘์†ํ•œ ์„œ๋ฒ„์—์„œ ์‹คํ–‰ํ•œ ๋ช…๋ น์–ด๋ฅผ ๊ธฐ๋กํ•ฉ๋‹ˆ๋‹ค.

Session Logs

700MB๋ฅผ ์ดˆ๊ณผํ•˜๋Š” ์ฝ˜ํ…์ธ ๋Š” ํŒŒ์ผ์„ ๋‹ค์šด๋กœ๋“œํ•˜์—ฌ ํ”Œ๋ ˆ์ดํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค.

  • Download ๋ฒ„ํŠผ์„ ๋ˆ„๋ฅด๋ฉด ๋‹ค์šด๋กœ๋“œ๊ฐ€ ์ง„ํ–‰๋˜์–ด ๋กœ์ปฌ์— ํŒŒ์ผ์ด ์ƒ์„ฑ๋ฉ๋‹ˆ๋‹ค.
  • ์„œ๋ฒ„ ์ ‘์† ์„ธ์…˜์„ ๋ ˆ์ฝ”๋”ฉํ•ฉ๋‹ˆ๋‹ค. ๊ด€๋ฆฌ์ž๋Š” ์˜์ƒ ์žฌ์ƒ์„ ํ†ตํ•˜์—ฌ ์„œ๋ฒ„๋‚ด์—์„œ ์‚ฌ์šฉ์ž์˜ ์ž‘์—… ์ˆ˜ํ–‰ ์ด๋ ฅ์„ ๋ชจ๋‹ˆํ„ฐ๋งํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

Session Monitoring

  • QueryPie๋ฅผ ํ†ตํ•œ ์„œ๋ฒ„ ์ ‘์† ์„ธ์…˜์„ ์กฐํšŒํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค
  • ๋˜ํ•œ ์ ‘์† ์ค‘์ธ ์„ธ์…˜์„ ์„ ํƒํ•˜์—ฌ Kill Sessions ๋ฒ„ํŠผ์„ ํด๋ฆญํ•ด ๊ฐ•์ œ์ข…๋ฃŒ ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

Access Control Logs

  • ์ฟผ๋ฆฌํŒŒ์ด ์‚ฌ์šฉ์ž/๊ทธ๋ฃน์— ๋ถ€์—ฌ๋˜๋Š” ์„œ๋ฒ„ ์ ‘๊ทผ Direct Permission์— ๋Œ€ํ•œ ๋ถ€์—ฌ ๋ฐ ํšŒ์ˆ˜ ์ด๋ ฅ์„ ๊ธฐ๋กํ•ฉ๋‹ˆ๋‹ค.
  • Direct Permission์€ Access Control ๋ฉ”๋‰ด์˜ Servers ํƒญ์—์„œ ์ฒ˜๋ฆฌ๋ฉ๋‹ˆ๋‹ค.

Server Role History

  • ์ฟผ๋ฆฌํŒŒ์ด ์‚ฌ์šฉ์ž/๊ทธ๋ฃน์— ๋ถ€์—ฌ๋˜๋Š” ์„œ๋ฒ„ ์ ‘๊ทผ Role์— ๋Œ€ํ•œ ๋ถ€์—ฌ ๋ฐ ํšŒ์ˆ˜ ์ด๋ ฅ์„ ๊ธฐ๋กํ•ฉ๋‹ˆ๋‹ค.
  • Role์˜ ๋ถ€์—ฌ ๋ฐ ํšŒ์ˆ˜๋Š” Access Control ๋ฉ”๋‰ด์˜ Roles ํƒญ์—์„œ ์ฒ˜๋ฆฌ๋ฉ๋‹ˆ๋‹ค.

Account Lock History

์‚ฌ์ „ ์กฐ๊ฑด: Security ๋ฉ”๋‰ด์—์„œ Maximum OS Account Login Failures before Lockout ์ •์ฑ…์„ ๋”ฐ๋ฆ…๋‹ˆ๋‹ค.

  • QueryPie์˜ ์‚ฌ์šฉ์ž๋ณ„ ์„œ๋ฒ„ ์ ‘์† ๊ถŒํ•œ ์ž ๊น€ ์ด๋ ฅ์„ ํ‘œ์‹œํ•ฉ๋‹ˆ๋‹ค.
  • ํŒจ์Šค์›Œ๋“œ ์˜ค์ž…๋ ฅ, ๋น„์ธ๊ฐ€ IP์˜ ์ ‘์† ์‹œ๋„ ๋“ฑ ์ ‘์† ์‹คํŒจํ•œ ํšŸ์ˆ˜๋ฅผ ๋ชจ๋‘ ์นด์šดํŠธ ํ•˜๋ฉฐ, ๊ด€๋ฆฌ์ž๊ฐ€ ์„ค์ •ํ•œ ์ ‘์† ์‹คํŒจ ์ž„๊ณ„์น˜ ๋„๋‹ฌ์‹œ ์ ‘์† ๊ณ„์ •์ด Lock ์ƒํƒœ๊ฐ€ ๋ฉ๋‹ˆ๋‹ค.
  • Blocked Accounts ๋ฉ”๋‰ด์—์„œ ์ž ๊ธด ๊ณ„์ •์„ ๋‹ค์‹œ ํ™œ์„ฑํ™”ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.
์‹œ์Šคํ…œ ์˜์—ญ์˜ ๊ฐ์‚ฌ ๋กœ๊ทธ๋ฅผ ํ™•์ธํ•˜๋Š” ๋ฐฉ๋ฒ• | QueryPie