Assignment 12

Security and schema

1. Create a new schema called "Human Resources"

2. Create a view owned by the HumanResources schema that combines the Person, Address, Employee and contacts table.

3. Create a new SqlServer login for sue with a password "Pa$$w0rd"

4. Create a new user for CommunityAssist for the login sue that has a default schema of HumanResources.

5. Grant the new user select permissions on the schema HumanResources

6. Log in as Sue. What can you see and access