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 login.…However, if you have Azure Active Directory…

Resume Transcript Auto-Scroll

Author

Released

9/11/2018

Learn how to protect databases and preserve the integrity of an organization's data by configuring the security settings in SQL Server. This course covers how to use built-in options on Microsoft platforms, including Azure AD, to secure database and network infrastructure. Learn about establishing users, assigning roles, and granting privileges. Find out how to prevent SQL Server from malicious injection by addressing vulnerabilities. Discover how to encrypt data at rest and in-transit. See how to build a robust security model for your applications. Additionally, learn how to encrypt connections and secure a network.