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, ...
Next you need to grant her access to the boxes, and that's where the security becomes a bit more complex. Inside every database are various objects, such as tables, views, stored procedures (bits of ...
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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results