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 48 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
Gracias!

CAPTAINAMERICA

  • Member
  • Posts: 325
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

About 80% of major fungal systemic infections are due to Candida albicans. Another form, Candida peritonitis, occurs most often in postoperative patients. A rare disease, Candida meningitis, may follow leukemia, kidney transplant, other immunosuppressed factors, or when suffering from Candida septicemia.

Did you know?

Recent studies have shown that the number of medication errors increases in relation to the number of orders that are verified per pharmacist, per work shift.

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?

Alcohol acts as a diuretic. Eight ounces of water is needed to metabolize just 1 ounce of alcohol.

Did you know?

The immune system needs 9.5 hours of sleep in total darkness to recharge completely.

The Mass-Luminosity Relation The Mass-Luminosity Relation
How to determine an exponential relation from a table of values How to determine an exponential relation from a table of values
Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ... Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ...
Please explain the different Rf values for xanthophyll’s in paper chromatography compared to ... Please explain the different Rf values for xanthophyll’s in paper chromatography compared to ...
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 ...
Explain the myogenic autoregulation of the glomerular filtration rate Explain the myogenic autoregulation of the glomerular filtration rate
Video: Introduction to filtration - filtrate formation and composition

For a complete list of videos, visit our video library