Daily Archives: May 17, 2011

Checking Permissions

Posted on May 17, 2011 by way0utwest

Someone posted this query recently: select a.*,name, b.* from sys.database_principals a, sys.database_permissions b where permission_name = ‘INSERT’ and b.grantee_principal_id = a.principal_id That’s a little ugly, so let’s fix it: SELECT  a.name, a.principal_id, a.is_fixed_role       , a.default_schema_name       , b.permission_name, b.permission_name … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Checking Permissions

Working Long or Working Hard

Posted on May 17, 2011 by way0utwest

Seth Godin has some very interesting things to say and often makes me think with his short posts on the world. I saw him speak a few years ago, enjoyed it, and while I don’t always agree with the way … Continue reading →

Posted in Editorial | Tagged | Comments Off on Working Long or Working Hard