SQL Server Permission Manager is a suite of scripts that allows you to take "snapshots" of users and permissions across any or all of the databases on your SQL Server. These snapshots then allow you ...

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server.

In SQL Server, you can create roles and define permissions for these roles using Transact-SQL (T-SQL) statements. Users are then assigned to appropriate roles based on their job requirements.

This script generates SQL commands to display the permissions of a specified user within all databases on a SQL Server instance, excluding the system databases (master, tempdb, model, msdb). Grant ...

Kevin Kline, president of the user group for Microsoft's SQL Server database, said in an interview that most companies have yet to make "a strong commitment" to the year-old SQL Server 2005 release.

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 ...

Several attendees at a conference of SQL Server users said Microsoft can do more to secure its SQL Server database, and company executives detailed plans aimed at meeting those demands as part of ...