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 89 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
:D TYSM

bimper21

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

« previous next »
 

Did you know?

There are approximately 3 million unintended pregnancies in the United States each year.

Did you know?

The largest baby ever born weighed more than 23 pounds but died just 11 hours after his birth in 1879. The largest surviving baby was born in October 2009 in Sumatra, Indonesia, and weighed an astounding 19.2 pounds at birth.

Did you know?

On average, someone in the United States has a stroke about every 40 seconds. This is about 795,000 people per year.

Did you know?

The oldest recorded age was 122. Madame Jeanne Calment was born in France in 1875 and died in 1997. She was a vegetarian and loved olive oil, port wine, and chocolate.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

The Mass-Luminosity Relation The Mass-Luminosity Relation
The Mass-Luminosity Relation The Mass-Luminosity Relation
How to find the maximum and minimum of a quadratic relation How to find the maximum and minimum of a quadratic relation
Mechanisms to Explain the Effects of Massage Mechanisms to Explain the Effects of Massage
Posterior view of midbrain in relation to brain stem Posterior view of midbrain in relation to brain stem
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 ...
Video: Functional zones in a mitochondrion

For a complete list of videos, visit our video library