SQL Server security – (Part 6) Author: Basit A. Farooq Editor’s note: In this part, you’ll learn how to create and manage application roles. Application roles You create an application role when you want an application to have a specific level of access, regardless of who’s using the application. You can use an application role to ensure that certain functions […]
Tag: application roles
SQL Server security – (Part 5)
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 […]