TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Total security in a PostgreSQL database

27 pointsby thejoover 15 years ago

2 comments

tptacekover 15 years ago
I've only skimmed this, but it looks like a great post, covering an area of database security almost everyone overlooks. There is no reason your app needs to run with carte blanche access to every table in the database, especially when your app is primarily driven by reads.<p>I've been on pentest engagements where clients have survived rather horrible SQL injection vulnerabilities because the database handle the injection happened on had no meaningful privileges.
评论 #953274 未加载
mark_l_watsonover 15 years ago
A great article! It made me realize that I need to be much more careful in setting up restrictions for PostgreSQL users (i.e., client applications).