Question: Create a login and database user Sam. If you get a server principal already exists error you know from our video on Authentication that a
Create a login and database user Sam. If you get a server principal already exists error you know from our video on Authentication that a login Sam already exists. If that is the case you will need to use a different login than Sam. The new login needs to be unique I would suggest your firstnamelastname. Sam or your own database user name should have select, delete, insert, and update authorization to all tables in your database. Sam or your own database user name should not have access to change the structure of the tables in your database.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
