In SQL Server 2000, it was difficult to allow users to see the SQL Server Agent jobs on your database server without giving the user sysadmin permissions. SQL Server 2005 makes assigning this ...

Newcomers to SQL Server always seem to confuse the ... We flippantly refer to Database User Accounts as “users” but this creates great confusion since Windows User Accounts are also called ...

Examine how roles play a part in keeping SQL Server secure. Most SQL Server databases have a number of users viewing and accessing data, which makes security a major concern for the administrator.

backups and even creating SQL server logins. Today we are extending our look at user accounts by creating database users and then adding them to specific roles for to provide the proper level of ...