From the course: SQL Server: Security for Developers

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Roles in Azure SQL Database

Roles in Azure SQL Database - SQL Server Tutorial

From the course: SQL Server: Security for Developers

Start my 1-month free trial

Roles in Azure SQL Database

“

- [Instructor] Azure SQL Database, Microsoft's database platform as a service offering, has its own nuances when we talk about security and roles. While it has some overlap with the way SQL Server works in terms of how roles and permissions are granted, the system roles and some other things are slightly different within Azure SQL DB as opposed to on premises SQL Server. And you should be aware of that, so let's walk through some of them. So we have a couple of options. The first thing that happens is we create a logical SQL Server. And this is kind of a weird concept with Azure SQL Database, but the logical server is really just a container for all of your individual databases that are managed separately. They're more like plug and play components. We create a server admin. The server admin has full admin access to the server. It can create new databases. It can manage users and all those sorts of things. By default this is a SQL user. When you create your server this will be a SQL…

Contents