Developing an application using a least-privileged user account (LUA) approach is an important part of a defensive, in-depth strategy for countering security threats. The LUA approach ensures that ...

When you create database objects, you must explicitly grant permissions to make them accessible to users. Every securable object has permissions that can be granted to a principal using permission ...

Learn tips for administering SQL Server securely.Of course, you might not have a domain at all. In this case, each server maintains its own SID database of users and objects. If users want access to ...

How do I assign permissions to users to see SQL Agent Jobs? Your email has been sent You can give your users rights to check if reports have run or jobs are complete without granting full admin rights ...

I have worked with SQL Server for many years now, back to Sybase SQL Server days and there has always been confusion over Logins and Users. Even though they typically use the same name they are ...

Hoping to pull from the hive mind on this one. I'm wondering if there is a way for someone to be able to do maintenance work on a sql server without actually being able to look at the data. What kind ...

Regardless of the platform a web application is running on, configuring permissions on the server side is tough. If your application needs to interact with the file system on the server, or the ...