SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part ...

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

SQL Server 2005 makes assigning this permission much easier through the use of new database roles in the msdb database. The SQLAgentReaderRole is a database role located in the msdb database.

The script has been tested on SQL Server 2005 and SQL Server 2008 ... to clear the same database but without the ALTER permission, as would be the case with only the DataReader and DataWriter database ...