[SQL] Create Service Account with Limited Access - BONUS: Connect SQL to PowerBI

Описание: We cover creating a new Login for your SQL server, granting limiting access, revoking access, deleting the login, and as a BONUS I'll show how to connect to SQL server in PowerBI using your new service account.

❔ What is a service account?
It is a login that is not associated with a specific person. It is a login created for processes or reporting, which is typically restricted to only the objects that the login needs to perform a specific job. In this case, we made a service account for reporting, so it was granted only "Select" access to a specific table.

Service accounts are helpful because if an automated process or report were using the credentials of an individual employee, then if the employee were to leave the company and their access was deactivated, then those processes or reports would fail. Using a service account helps deter service disruptions, and allows more collaboration with other teams in your company while simultaneously promoting security and segregation of duties by granting limited access.

🔴 IF YOU WANT THE CODE: 🔴
Go to our GitHub at https://github.com/VeeBeeCoding/YouTu....
The file name will match the YouTube title name for the corresponding video.

🔗 Other Links
Instagram -   / veebeecoding  
Ko-fi - https://ko-fi.com/veebeecoding

/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\

🖐Hi! I'm VeeBee, you can call me VB or Bee for short! Over the years during my career I have been keeping a journal of what I have learned when working in different languages and projects.

🏁 My goal is to pass along what I have learned to you by teaching through projects and exercises based on real world experiences.

✨ My promise to you is that I will do my best to not waste time. Each video will have a full summary at the very beginning so that you can determine if you can skip the video if you already know the material, or the summary can be a refresher if you're coming back.

/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\

☕ If you found this tutorial helpful and would like to spot me a coffee as thanks, please consider leaving a small tip or donation on my Ko-Fi site at https://ko-fi.com/veebeecoding.
Tips are never expected, but always appreciated! I plan on creating content regardless, so there is no pressure or obligation to donate.