From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Manage authentication and authorization using T-SQL

Manage authentication and authorization using T-SQL

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Manage authentication and authorization using T-SQL

“

- Welcome back. This is lesson 4.7: Manage Authentication and Authorization by Using T-SQL. So to access any of these SQL offerings, you need to create a login for authentication and a user for authorization. So let's begin with authentication and show how to manage authentication using T-SQL. And we'll start with Create login. The create login creates a login for the different SQL offerings. You need to create a login for Azure SQL Database or Azure SQL Managed instance. The create login creates a login for those SQL offerings. Now you can create different kinds of logins. For example, you can create a login with a password, and this creates a SQL Server login only with a username and password. From external provider specifies that the login is mapped to a Microsoft External Principal. You can also alter logins and this changes the properties of a login. For example, you can reset a password or you can enable or disable a login. So from an authentication standpoint, create the login…

Contents