Assignment 12

Creating Logins, Users and roles

This is fairly simple

1. Create a new login called CustLogin which has a password of "P@ssw0rd1" and the default database "Automart."

2. Create a new User that uses the login CustLogin called CustUser with a default schema of Customer

3. Create a role called CustomerRole.

4. Grant select on the Customer schema to the role Customer Role

5. Use the stored procedure to add the user CustUser to the Role Customer

You should try to log on as the new user and see if everything is working as it should. You should only be able to see those tables and objects that belong to the customer schema. You should only be able to select, not insert update or delete

---

What I am looking for

Each step is worth 2 points for a total of 10

---

What to turn in

copy the code into a Google doc and share it with spconger@gmail.com