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 183 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
Great answer, keep it coming :)

Alyson.hiatt@yahoo.com

  • Member
  • Posts: 354
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Did you know?

It is difficult to obtain enough calcium without consuming milk or other dairy foods.

Did you know?

Looking at the sun may not only cause headache and distort your vision temporarily, but it can also cause permanent eye damage. Any exposure to sunlight adds to the cumulative effects of ultraviolet (UV) radiation on your eyes. UV exposure has been linked to eye disorders such as macular degeneration, solar retinitis, and corneal dystrophies.

Did you know?

The longest a person has survived after a heart transplant is 24 years.

Did you know?

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

Difference between Functional and Cross-Functional team Difference between Functional and Cross-Functional team
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 ...
Difference-Between-Carbohydrates-and-Lipids-infographic Difference-Between-Carbohydrates-and-Lipids-infographic
Please explain the different Rf values for xanthophyll’s in paper chromatography compared to ... Please explain the different Rf values for xanthophyll’s in paper chromatography compared to ...
An electron is accelerated from rest through a potential difference. After acceleration the ... An electron is accelerated from rest through a potential difference. After acceleration the ...
Video: Mechanisms of capillary exchange

For a complete list of videos, visit our video library