You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When stacked queries is supported use OPENROWSET (MSSQL) and dblink() (PostgreSQL) to run a statement as a different user (e.g. higher privileged user for instance after a password cracking attack).
As of PostgreSQL 9.1, dblink() function is still in the contrib folder and not packaged by default:
[...] modules that can be found in the contrib directory of the PostgreSQL distribution. These include porting tools, analysis utilities, and plug-in features that are not part of the core PostgreSQL system [...]
It requires the DBA to manually compile PostgreSQL and run the dblink.sql statement to create the function before being usable.
Hence, shall we support it despite there're very little chances we ever find it available? Comments are welcome.
Currently Google says 135.000 results for search query: dblink postgresql. That doesn't say anything that if the task is not too hard to be accomplished it wouldn't be something of total lack of practical usage.
Activity
added skeleton code for issue #34, still not usable
bdamele commentedon Jul 2, 2012
First rough implementation in commit 6697927 (forgot to reference this issue in the commit message)
more tweaking for issue #34, it's totally not as trivial as it may lo…
cleanup for #34
finally got this working on MSSQL 2005: commands can now be executed …
bdamele commentedon Jul 9, 2012
Done for MSSQL.
bdamele commentedon Jul 12, 2012
As of PostgreSQL 9.1, dblink() function is still in the contrib folder and not packaged by default:
It requires the DBA to manually compile PostgreSQL and run the dblink.sql statement to create the function before being usable.
Hence, shall we support it despite there're very little chances we ever find it available? Comments are welcome.
stamparm commentedon Jul 12, 2012
Currently Google says 135.000 results for search query: dblink postgresql. That doesn't say anything that if the task is not too hard to be accomplished it wouldn't be something of total lack of practical usage.