SQL Server Database Engine Permission Posters

SQL Server Database Engine Permission Posters

Posters are available that list all the granular permissions of the SQL Server Database Engine and Windows Azure SQL Database. Select the pdf images below. You can display these on your computer, expanding or shrinking them to focus on specific areas. Use Control+F to search for a specific permission. You may print these posters for your personal use. Without adjustment they print at approximately 2 by 3 feet.
The posters are also available in the Server Posterpedia app available for Windows 8.

Windows Azure SQL Database

Revised version as a PNG graphic.

SQL Server 2012

6327.Permissions_Poster_2012.pdf

SQL Server 2008 R2

5710.Permissions_Poster_2008_R2_Wiki.pdf



 

 

 

Leave a Comment
  • Please add 3 and 6 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Rick Byham, Microsoft edited Revision 9. Comment: Added Server Posterpedia reference.

  • Rick Byham, Microsoft edited Revision 8. Comment: Removing the old version.

  • Rick Byham, Microsoft edited Revision 7. Comment: Inserting 150 DPI version of the SQL Database poster

  • Rick Byham, Microsoft edited Revision 4. Comment: Changing the SQL Database poster to the modern versions

  • Rick Byham, Microsoft edited Revision 5. Comment: New Graphic doesn't appear properly

  • Rick Byham, Microsoft edited Revision 2. Comment: Reversing the order of presentation.

  • Rick Byham, Microsoft edited Revision 1. Comment: Adding 2012 and Windows Azure SQL Database versions.

Page 1 of 1 (7 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Rick Byham, Microsoft edited Revision 1. Comment: Adding 2012 and Windows Azure SQL Database versions.

  • Rick Byham, Microsoft edited Revision 2. Comment: Reversing the order of presentation.

  • These are great, Does MS create these and mail them out?

  • Not at this time. They work really well on your Windows tablet though.

  • Rick Byham, Microsoft edited Revision 4. Comment: Changing the SQL Database poster to the modern versions

  • Rick Byham, Microsoft edited Revision 5. Comment: New Graphic doesn't appear properly

  • Rick Byham, Microsoft edited Revision 7. Comment: Inserting 150 DPI version of the SQL Database poster

  • Rick Byham, Microsoft edited Revision 8. Comment: Removing the old version.

  • Rick Byham, Microsoft edited Revision 9. Comment: Added Server Posterpedia reference.

  • Now available on Windows 8 as part of the Server Posterpedia app available in the Windows 8 Store.

  • Okay, but some of us are going to be dealing with SS2005 and SS2008 for a while.  Are there posters for the older version available, and if not why not?  Though these might have a level of compatibility with those older versions, the older posters would be just as great, and probably more accurate, as well.

  • SQL Server 2008 and SQL Server 2008 R2 have the same permissions. No, I don't have any plans to create a SQL Server 2005 version. SQL Server 2005 is lacking ALTER ANY SERVER AUDIT and ALTER ANY DATABASE AUDIT. And the red SQL Server 2008 R2 version mentions that the SERVER ROLE and AVAILABILITY GROUP permissions only apply starting with SQL Server 2012.

Page 1 of 1 (12 items)