Odbcng

= Pattern Match Feature =

Also known as allowable objects, this feature allows the administrator to configure the DSN to only see specific objects within the database. This feature was created because PostgreSQL allows any user to see objects within the database regardless of permission.

Note that this is a secure through obscure type feature and is not a replacement for good and solid role implementation.

{{{

it apply pattern from field ALLOWED_OBJECTS of connection string to all objects in FROM construction, except functions.

Query will be checked only if it have FROM construction.

- pattern case sensitive

- if pattern contains only table name, this table is in public scheme. E.g.

   info*.*, tabl_*

same as

   info*.*, public.tabl_*

- if query contains table name without schema name - for checking used public pattern.

}}}