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 110 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
Excellent

carojassy25

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

« previous next »
 

Did you know?

No drugs are available to relieve parathyroid disease. Parathyroid disease is caused by a parathyroid tumor, and it needs to be removed by surgery.

Did you know?

Vaccines cause herd immunity. If the majority of people in a community have been vaccinated against a disease, an unvaccinated person is less likely to get the disease since others are less likely to become sick from it and spread the disease.

Did you know?

Anesthesia awareness is a potentially disturbing adverse effect wherein patients who have been paralyzed with muscle relaxants may awaken. They may be aware of their surroundings but unable to communicate or move. Neurologic monitoring equipment that helps to more closely check the patient's anesthesia stages is now available to avoid the occurrence of anesthesia awareness.

Did you know?

The Food and Drug Administration has approved Risperdal, an adult antipsychotic drug, for the symptomatic treatment of irritability in children and adolescents with autism. The approval is the first for the use of a drug to treat behaviors associated with autism in children. These behaviors are included under the general heading of irritability and include aggression, deliberate self-injury, and temper tantrums.

Did you know?

You should not take more than 1,000 mg of vitamin E per day. Doses above this amount increase the risk of bleeding problems that can lead to a stroke.

Physical assessment is one component of the nursing database Physical assessment is one component of the nursing database
Jugular Venous Pulse Waves in Relation to the Phonocardiogram and Electrocardiogram Jugular Venous Pulse Waves in Relation to the Phonocardiogram and Electrocardiogram
This modified model of Easton’s systems theory puts government decision makers as the source of pol This modified model of Easton’s systems theory puts government decision makers as the source of pol
The relation between a raw EMG signal and its integrated version. The volunteer tensed her muscle ... The relation between a raw EMG signal and its integrated version. The volunteer tensed her muscle ...
Posterior view of midbrain in relation to brain stem Posterior view of midbrain in relation to brain stem
Please fully explain in detail Please fully explain in detail
Video: Mendel's Principles of Dominance, Segregation and Independent Assortment

For a complete list of videos, visit our video library