Permissions

Tag: permissions

DBAs: Stop Denying Sysadmin to Developers

DBAs: Stop Denying Sysadmin to Developers

I recently chatted with some folks who have a permissions problem in SQL Server. The permissions problem isn’t technical: it’s a process problem.

Continue reading

Checking Permissions on Linked Servers

Checking Permissions on Linked Servers

By Kendra Little on April 21, 2009

Category: security

One reason I started this blog was just the idea of going through my catalog of scripts and reviewing them and sharing out what might be useful to people.

Here is a quick one I put together a while back. I was starting to work with a group of servers [at an unnamed company, always an unnamed company!]. Some of the instances had been configured long ago, and I found some linked servers where passwords had been hardcoded into the login mappings.

Continue reading