PGXN

PostgreSQL Extension Network

PGXN Gear PostgreSQL Extension Network
  • kop
  • pg_isok 0.1.3
  • appendix-Security-Considerations
  • Users
  • Tags
  • Recent

Contents

    • A. Security Considerations
A. Security Considerations
Prev     Next

A. Security Considerations

The security concerns surrounding Isok are many, and can be complex. Fundamentally, this is because Isok executes arbitrary SQL. If the wrong SQL is executed, in the wrong context, anything might happen to your data. This appendix identifies pertinent issues, and how to minimize risk.

Ultimately, these are the same issues that arise in any application that executes SQL. The big difference between Isok and other applications is that most applications execute a more-or-less limited number of SQL queries that are carefully crafted to suit a specific purpose. The queries executed by Isok can have much more variation, and be subject to less review.

In the end, the recommendations here come down to following generally accepted security best-practices, in particular, the principle of least privilege.


Prev     Next
run_isok_queries  Home  Limiting Access

Page generated: 2025-06-03T21:00:20-05:00.

Blog | Mastodon | Release on PGXN About | FAQ | Mirroring | Feedback