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 213 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!

laurnthompson

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

« previous next »
 

Did you know?

Coca-Cola originally used coca leaves and caffeine from the African kola nut. It was advertised as a therapeutic agent and "pickerupper." Eventually, its formulation was changed, and the coca leaves were removed because of the effects of regulation on cocaine-related products.

Did you know?

Though the United States has largely rejected the metric system, it is used for currency, as in 100 pennies = 1 dollar. Previously, the British currency system was used, with measurements such as 12 pence to the shilling, and 20 shillings to the pound.

Did you know?

The average older adult in the United States takes five prescription drugs per day. Half of these drugs contain a sedative. Alcohol should therefore be avoided by most senior citizens because of the dangerous interactions between alcohol and sedatives.

Did you know?

According to the FDA, adverse drug events harmed or killed approximately 1,200,000 people in the United States in the year 2015.

Did you know?

Eating food that has been cooked with poppy seeds may cause you to fail a drug screening test, because the seeds contain enough opiate alkaloids to register as a positive.

Flower part number is a characteristic difference between monocots and eudicots Flower part number is a characteristic difference between monocots and eudicots
Windows Windows
Please fully explain the answer with steps Please fully explain the answer with steps
Explain the assumptions that must be satisfied in order to validly use the one-way ANOVA ... Explain the assumptions that must be satisfied in order to validly use the one-way ANOVA ...
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 ...
Solve Diophantus’s Problem B–8: To find two numbers such that their difference a Solve Diophantus’s Problem B–8: To find two numbers such that their difference a
Video: Subunits of DNA And Semi Conservative Replication

For a complete list of videos, visit our video library