SQL Server security – (Part 5) Author: Basit A. Farooq Editor’s note: In this part, you’ll learn how to manage securables at the database and schema scope. You’ll learn how to use fixed database roles and how to create custom database roles to manage permissions. Database and schema securables – Overview Each database has a number of securables that inherit […]
Tag: database roles
Troubleshooting SQL Server 2012 Roles
Troubleshooting SQL Server 2012 Roles If you have problems with SQL Server 2012 roles, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 roles bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this article was...