Repository navigation
Feature Request: Schema/Table Qualification Enforcement in check command #1161
AndrewJackson2020
started this conversation in
Ideas
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
It would be a nice security feature to allow `postgres-language-server check to be able to optionally detect any non schema/table qualified references. Any reference that is not schema qualified will go to the search path to look up a given object. This is the source of a number of security vulnerabilities in postgres SQL code. Full compliance with all of these checks may be too verbose for some purposes but in highly secure environments it is a nice defense in depth measure when combined with explicitly setting search path, preferring secrurity invoker functions over security definer functions, etc. The checks that I am thinking about are listed below.
Let me know what you think.
table schema qualified
function schema qualified
column table qualified
type schema qualified
operator schema qualified
All reactions