nalgeon / sqlean

The ultimate set of SQLite extensions
MIT License
3.72k stars 118 forks source link

Flag potential security risks in extensions #85

Closed mhalle closed 1 year ago

mhalle commented 1 year ago

Several extensions offer functionality through select that may pose a security risk if used in an environment that allows arbitrary queries.

These extensions should be flagged as potential risks in their documentation.

For example, fileio operations could permit arbitrary access to the file system. env operations could allow access to private information such as secret values set using environment variables.

While accessing these extensions requires that they be explicitly loaded, a naive client app may do so without consideration of the potential security risks. A prominent warning in the documentation may be a suitable safety measure, though other precautions may be warranted.

E

jlarmstrongiv commented 1 year ago

Another such function is eval()

nalgeon commented 1 year ago

I believe that the extension documentation explains the functionality enough for a user to make an informed decision.