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

covalentbond

  • Member
  • Posts: 336
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

The first-known contraceptive was crocodile dung, used in Egypt in 2000 BC. Condoms were also reportedly used, made of animal bladders or intestines.

Did you know?

Nitroglycerin is used to alleviate various heart-related conditions, and it is also the chief component of dynamite (but mixed in a solid clay base to stabilize it).

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

In 1844, Charles Goodyear obtained the first patent for a rubber condom.

Did you know?

When blood is deoxygenated and flowing back to the heart through the veins, it is dark reddish-blue in color. Blood in the arteries that is oxygenated and flowing out to the body is bright red. Whereas arterial blood comes out in spurts, venous blood flows.

The Mass-Luminosity Relation The Mass-Luminosity Relation
The Period-Luminosity Relation The Period-Luminosity Relation
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
E9-23 Prepare income statements Explain the difference in operating income E9-23 Prepare income statements Explain the difference in operating income
Please fully explain in detail Please fully explain in detail
Video: Automated external defibrillator (AED)

For a complete list of videos, visit our video library