Tag Archives: security

Rights for one table

Posted on September 16, 2010 by way0utwest

I ran across a thread that was asking how to grant rights to a person for one table only, and not other tables. My response is simple: CREATE ROLE MySingleTableRoleGOGRANT SELECT ON dbo.MyCustomers TO MySingleTableRoleGOEXEC sp_addrolemember ‘MySingleTableRole’, ‘Steve’ That’s it. … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Rights for one table

Social Engineering Dangers

Posted on September 15, 2010 by way0utwest

I heard about a social engineering contest at this year’s DefCon hacker conference. The write-up said that every company targeted would have failed in a security audit, and these were some large companies, like Google, BP, Proctor and Gamble, Microsoft … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Social Engineering Dangers

Check Twice, Update Once

Posted on September 2, 2010 by way0utwest

An update to the Microsoft Best Practices Analyzer tool intrigues Steve Jones as it seems to have been enhanced to better help DBAs manage SQL Server. Continue reading →

Posted in Editorial | Tagged , | Comments Off on Check Twice, Update Once

Security Panics

Posted on August 23, 2010 by way0utwest

I went to host the Red Gate SQL Source Control webinar recently and had a snag. I downloaded the GoToWebinar software (why must I download this every time?) and when I ran it, I got an error. First it was … Continue reading →

Posted in Blog | Tagged , | Comments Off on Security Panics