This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Explain the difference between Windows Authentication vs. SQL Server Authentication in SQL Server. ... (Read 156 times)

Pineappleeh

  • Hero Member
  • *****
  • Posts: 585
on: Jul 7, 2018
Explain the difference between Windows Authentication vs. SQL Server Authentication in SQL Server.
 
  What will be an ideal response?

Question 2

Explain what is happening in the code sample below.GRANT EXEC ON usp_StudentLogIn TO StudentRoleCREATE USER StudentUser FOR LOGIN StudentLoginEXEC sys.sp_addrolemembe r StudentRole, StudentUser
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

Zebsrer

  • Sr. Member
  • ****
  • Posts: 284
Reply #1 on: Jul 7, 2018
Answer to Question 1

With Windows authentication the user is authenticated by logging into Windows. The Windows login is mapped to a SQL Server login. If there are users who don't have a Windows login, SQL Server can enable mixed logins. With mixed logins a user can login directly to the SQL Server by providing a username and password.

Answer to Question 2

The first command grants permission to execute a stored procedure to the StudentRole. The second command creates a new user based on the student login. The final command executes a system stored procedure that adds the new user to the role.


Pineappleeh

  • Member
  • Posts: 585
Reply 2 on: Jul 7, 2018
Gracias!

at

  • Member
  • Posts: 359
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

Only 12 hours after an egg cell is fertilized by a sperm cell, the egg cell starts to divide. As it continues to divide, it moves along the fallopian tube toward the uterus at about 1 inch per day.

Did you know?

Parkinson's disease is both chronic and progressive. This means that it persists over a long period of time and that its symptoms grow worse over time.

Did you know?

Children of people with alcoholism are more inclined to drink alcohol or use hard drugs. In fact, they are 400 times more likely to use hard drugs than those who do not have a family history of alcohol addiction.

Did you know?

Though “Krazy Glue” or “Super Glue” has the ability to seal small wounds, it is not recommended for this purpose since it contains many substances that should not enter the body through the skin, and may be harmful.

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.

Methicilli ...
The difference between AZT-sensitive versus AZT-resistant reverse transcriptases The difference between AZT-sensitive versus AZT-resistant reverse transcriptases
“Windows” Through the Atmosphere “Windows” Through the Atmosphere
The difference between a human and an ape. The difference between a human and an ape.
How to Factor a Sum or Difference of Two Cubes How to Factor a Sum or Difference of Two Cubes
Resting Membrane Potential: Voltage Difference Resting Membrane Potential: Voltage Difference
Sensitivity study for facial difference Sensitivity study for facial difference
Video: Rods and Cones Animation

For a complete list of videos, visit our video library