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 136 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
Wow, this really help

bdobbins

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

« previous next »
 

Did you know?

A recent study has found that following a diet rich in berries may slow down the aging process of the brain. This diet apparently helps to keep dopamine levels much higher than are seen in normal individuals who do not eat berries as a regular part of their diet as they enter their later years.

Did you know?

Walt Disney helped combat malaria by making an animated film in 1943 called The Winged Scourge. This short film starred the seven dwarfs and taught children that mosquitos transmit malaria, which is a very bad disease. It advocated the killing of mosquitos to stop the disease.

Did you know?

Drying your hands with a paper towel will reduce the bacterial count on your hands by 45–60%.

Did you know?

ACTH levels are normally highest in the early morning (between 6 and 8 A.M.) and lowest in the evening (between 6 and 11 P.M.). Therefore, a doctor who suspects abnormal levels looks for low ACTH in the morning and high ACTH in the evening.

Did you know?

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

Draw and label a diagram and explain how a factor-dependent transcription (rho-dependent) terminator Draw and label a diagram and explain how a factor-dependent transcription (rho-dependent) terminator
How to Factor a Sum or Difference of Two Cubes How to Factor a Sum or Difference of Two Cubes
Difference spectra of mitochondria Difference spectra of mitochondria
Please fully explain the answer with steps Please fully explain the answer with steps
Explain how it can be desirable from an intertemporal perspective for a country run a current ... Explain how it can be desirable from an intertemporal perspective for a country run a current ...
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: What is an ecosystem?

For a complete list of videos, visit our video library