There are two types of roles, one for the server and one for the database. Server roles are groups that allow you to control the management of SQL Server. They allow you to grant others the rights to ...

Ok, I'm trying to understand how to approach this.<BR><BR>I need to design a personnel database.<BR><BR>Employees can see all of their own records.<BR><BR>Managers can see all of the info for the ...

Because SQL Server manages security identifiers (SIDs) for any user logging into SQL Server, you risk "orphaning" users when you do a restore. It's a common problem, and here's why. Typically, ...

Application Roles offer a better, more secure way for users to gain access to SQL Server data. Here's why. They have been around forever, but have you really ever implemented Application Roles in SQL ...