Daily Archives: May 17, 2011

Checking Permissions

Posted on May 17, 2011 by

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 , ,

Working Long or Working Hard

Posted on May 17, 2011 by

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