1. Write SQL code to grant jdow permission to login to SQL Server (It is Windows Integrated authentication)

Use AdventureWorks

Grant Connect to jdow;

2. Write SQL code to add user jdow to database AdventureWorks2014. Note: you have to use "fully qualified" login name that includes VM's host name.

3. Add permissions for jdow to read and create tables in AdventureWorks2014. a. Check jdow's properties and provide a screenshot

4. Now use sp_who2 procedure to find information about your own login: SPID HostName ProgramName

5. In MS SQL Management Studio open another query window and change the session user by executing script similar to the following Try to select all products from Production.Product table (AdventureWorks2014 db). Explain results. a. How many rows were returned? Show on the screenshot that select statement was executed as jdow.

6. Try to create any table as the jdow. Use CREATE TABLE statement. Try to insert row in newly created table. a. Report your results. Show on the screenshot that create and insert statements were executed as jdow.

7. Close the query window where you are connected as jdow.Use xp_logininfo to find which OS accounts have log