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 211 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
YES! Correct, THANKS for helping me on my review

xoxo123

  • Member
  • Posts: 335
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

In 1835 it was discovered that a disease of silkworms known as muscardine could be transferred from one silkworm to another, and was caused by a fungus.

Did you know?

The shortest mature adult human of whom there is independent evidence was Gul Mohammed in India. In 1990, he was measured in New Delhi and stood 22.5 inches tall.

Did you know?

The Centers for Disease Control and Prevention has released reports detailing the deaths of infants (younger than 1 year of age) who died after being given cold and cough medications. This underscores the importance of educating parents that children younger than 2 years of age should never be given over-the-counter cold and cough medications without consulting their physicians.

Did you know?

Prostaglandins were first isolated from human semen in Sweden in the 1930s. They were so named because the researcher thought that they came from the prostate gland. In fact, prostaglandins exist and are synthesized in almost every cell of the body.

Did you know?

Asthma occurs in one in 11 children and in one in 12 adults. African Americans and Latinos have a higher risk for developing asthma than other groups.

A pharmacist can explain to a patient why medication may look different and ensure the correct ... A pharmacist can explain to a patient why medication may look different and ensure the correct ...
The slight (5 microsecond) difference in the firing of the companion cylinders is enough time to ... The slight (5 microsecond) difference in the firing of the companion cylinders is enough time to ...
Mechanisms to Explain the Effects of Massage Mechanisms to Explain the Effects of Massage
Computer Literacy for IC3, Unit 2: Using Productivity Software, Update to Office 2013 & Windows ... Computer Literacy for IC3, Unit 2: Using Productivity Software, Update to Office 2013 & Windows ...
What's the Difference Between England, Great Britain, and United Kingdom? What's the Difference Between England, Great Britain, and United Kingdom?
Resting Membrane Potential: Voltage Difference Resting Membrane Potential: Voltage Difference
Video: ribosome

For a complete list of videos, visit our video library