Question: Create a login and database user Jane. If you get a server principal already exists error you know from our video on Authentication that a

Create a login and database user Jane. If you get a server principal already exists error you know from our video on Authentication that a login Jane already exists. If that is the case you will need to use a different login than Jane. The new login needs to be unique I would suggest your firstname_lastname. Jane (or your own database user name) should have read authorization to all the tables in your database. Jane (or your own database user name) should only have delete, insert and update authorization to the student table. Jane (our your own database user name) should not have delete, insert and update authorization to any other tables.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!