Overview
In this section, we cover the required permissions to be able to access the data and objects in the MSDB database.
Explanation
Who has access to the MSDB database and are there different levels of permissions?
MSDB becomes available to any user with public-level access to the instance. However, the list of available tables is limited and read-only.
The entire list of tables is made available with membership in db_datareader, db_owner, or the sysadmin fixed role. Write-level permissions to these tables are granted with db_datawriter, db_owner, or the sysadmin fixed role. Note that only sysadmin membership gives a user access to the SQL Server Agent GUI for jobs they do not own, but they will be able to modify the underlying tables directly with these database-level permissions.
Eric has been a SQL Server DBA and Architect in the legal, software, transportation, and insurance industries for over 10 years. Currently he is the Sr Data Architect for Squire Patton Boggs, a leading provider of legal services with 47 offices in 20 countries.
Eric is a 2018-2019 Idera Ace and has co-authored 2 Idera Whitepapers.
He has been a presenter at PASS Summit, IT/DevConnections, SQLSaturdays, the in.sight transportation conference, and the Ohio North SQL Server User’s Group.
- MSSQLTips Awards: Author of the Year Contender – 2021, 2022 | Trendsetter (25+ tips) – 2021
