When using SQL Server Authentication, logins are created in SQL Server that are not based on Windows
Question:
When using SQL Server Authentication, logins are created in SQL Server that are not based on Windows user accounts. Both the user name and the password are created by using SQL Server and stored in SQL Server. Users connecting using SQL Server Authentication must provide their credentials (login and password) every time that they connect. When using SQL Server Authentication, you must set strong passwords for all SQL Server accounts. Microsoft Docs.
One of the fundamental concepts of data security and access control is the AAA: authentication, authorization, and accounting.
For this assignment, you are to research to identify the actions you'd use to configure user authentication and authorization in SQL Server. In this discussion, show how the process might change for an administrator, named user, or a guest. Be detailed and fully explain the purpose and results of each step.
Accounting Information Systems
ISBN: 978-0133428537
13th edition
Authors: Marshall B. Romney, Paul J. Steinbart