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

Create a login and database user called Bob. If you get a server principal already exists error you know from our video on Authentication that a login Bob already exists. If that is the case you will need to use a different login than Bob. The new login needs to be unique I would suggest your firstname_lastname. After you create the login and database user what authorization does the database user have? Take a screenshot of your database user authorization.
Bob (or your own database user name) should only have access to the student table and no other tables in your database. Write the DCL script to give Bob (or your own database user name) the authorization to the student table.

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!