Tag Archives: sql

PostgreSQL Group & User Role Inheritance

As I’m trying to finish up one of my consulting projects (and enhance other active projects), I decided to take a nice long hard look a PostgreSQL permissions – the correct way of doing it. PostgreSQL applies the commonly accepted … Continue reading

Posted in SQL | Tagged , | Leave a comment

Update Orphaned MSSQL Users

I’ve been moving the databases at work from one Microsoft SQL 2005 server to another SQL 2005 Server. When the databases grant security to non-domain users, they have a tendency to not be attached / accessible on the new server. … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment