CSI-234 database II how to create sql server logins with varying access levels? Assignment: Create SQL Server

CSI-234 database II how to create sql server logins with varying access levels?

  
 
 
 
 
 
 

Transcribed Image Text:

Assignment: Create SQL Server Logins with Varying Access Levels Objective: Create 5 different logins for your SQL Server, each with varying levels of access that might commonly be needed in a deployed cloud database. Save the sql script for each user in the assignment repository. Server-level roles SQL Server | Microsoft Learn Database-Level Roles -SQL Server | Microsoft Learn Template:P Run on master CREATE LOGIN [LoginName] WITH PASSWORD [SecurePassword]: RUN on the database that you want the user to access CREATE USER [LoginName] FROM LOGIN [LoginName] Add the roles or permissions that you want the user to have based on the description Note: Replace [LoginName] with the actual name of the login and [SecurePassword] with a secure password. Assignment: Create SQL Server Logins with Varying Access Levels Objective: Create 5 different logins for your SQL Server, each with varying levels of access that might commonly be needed in a deployed cloud database. Save the sql script for each user in the assignment repository. Server-level roles SQL Server | Microsoft Learn Database-Level Roles -SQL Server | Microsoft Learn Template:P Run on master CREATE LOGIN [LoginName] WITH PASSWORD [SecurePassword]: RUN on the database that you want the user to access CREATE USER [LoginName] FROM LOGIN [LoginName] Add the roles or permissions that you want the user to have based on the description Note: Replace [LoginName] with the actual name of the login and [SecurePassword] with a secure password.