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.

Assigning a user or group to be a member of this role allows the user to see any SQL Agent job located on the server instance, even the jobs in which that user does not own. The user can see the ...

We have covered things such as viewing the state of databases, backups and even creating SQL server logins. Today we are extending our look at user accounts by creating database users and then adding ...