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

Author Question: Explain the relation between a SQL Server Login and a database user. What will be an ideal ... (Read 47 times)

j.rubin

  • Hero Member
  • *****
  • Posts: 557
on: Jul 7, 2018
Explain the relation between a SQL Server Login and a database user.
 
  What will be an ideal response?

Question 2

Explain the role of Authentication and Authorization in database security.
 
  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

recede

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

A SQL Server login grants access to the server itself, but it doesn't provide any permissions on databases. For that a database user is created. The database user is mapped to a particular login and then granted permissions on database objects.

Answer to Question 2

Authentication is the process of making sure a user is who he or she says they are. In SQL server this can be done by Windows, by user name and password or by validating a certificate. Authorization is the process of assigning permissions to a user who has been authenticated.


j.rubin

  • Member
  • Posts: 557
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review

phuda

  • Member
  • Posts: 348
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

This year, an estimated 1.4 million Americans will have a new or recurrent heart attack.

Did you know?

Disorders that may affect pharmacodynamics include genetic mutations, malnutrition, thyrotoxicosis, myasthenia gravis, Parkinson's disease, and certain forms of insulin-resistant diabetes mellitus.

Did you know?

There are more bacteria in your mouth than there are people in the world.

Did you know?

As many as 20% of Americans have been infected by the fungus known as Histoplasmosis. While most people are asymptomatic or only have slight symptoms, infection can progress to a rapid and potentially fatal superinfection.

Did you know?

Blastomycosis is often misdiagnosed, resulting in tragic outcomes. It is caused by a fungus living in moist soil, in wooded areas of the United States and Canada. If inhaled, the fungus can cause mild breathing problems that may worsen and cause serious illness and even death.

What are examples of ideal forms? What are examples of ideal forms?
The camshaft is rotated in relation to the camshaft by the PCM to provide changes in valve timing. The camshaft is rotated in relation to the camshaft by the PCM to provide changes in valve timing.
Posterior view of midbrain in relation to brain stem Posterior view of midbrain in relation to brain stem
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 ...
If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas? If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas?
Video: Anaphylaxis Animation

For a complete list of videos, visit our video library