One of the big changes I came upon as I transitioned from Oracle to PostgreSQL was how privileges are handled. In Oracle, an object’s schema also determines its owner, as the schema is generally that user’s objects. PostgreSQL disassociates schemas from users. Schemas do have owners, but a given user...
[Read More]
USAGE Privilege Prevents Dropping Users
ACLs FTW
The Incident
While cleaning up some obsolete user accounts, one of my DROP USER commands failed with:
[Read More]
Moved to GitHub Pages
Yet Another Beautiful Jekyll Site!
If you’re reading this, then the migration has worked. My blog is now hosted via GitHub Pages. Many thanks to Kris Rice for his Blogger migration blog post and source code to get me set.
[Read More]
Beware (Sort-Of) Ambiguous Column Names In Sub-Selects
This morning I received an UPDATE statement from a developer that I was testing. It ran without errors but then I saw that it updated 5 rows when it should have only updated 3. The reason gave me a little shock so I whipped up a simple test-case to reproduce...
[Read More]
How (Not) to Change Passwords in PostgreSQL
A few months ago I was doing some testing on a development PostgreSQL database and watching the postgresql server log (akin to Oracle's alert log). I was skimming for lines relevant to my testing when I noticed something chilling:LOG: statement: alter user john password 'IloveDBAs';The username and password have obviously...
[Read More]