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,600 courses taught by industry experts.

Configure security principals

Configure security principals

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

Configure security principals

“

- Welcome back. This is lesson 4.3: Configure Security Principals. In order to understand how to configure security principals, it first helps to understand what a security principals is. Security principals are entities that request SQL server access, and there's several levels of these. First is the server level security principal. These are things like SQL server authentication logins or server roles. Then you have database level principals. These are things like database users or database roles, and then you have schema level principals. A good example of this is the DBO. DBO schema is a special user principal in each database. So you have server level principals, database level principals, and schema level principals. Walking through an example of how to create a security principal, we can use several things. We can use T-SQL, for example, so in the master database we can create a login. And then in the database we create the user. Simple as that. Now we have a database level…

Contents