Describe and implement best practices for user administration SQL Server

computer science

Description

Objectives

Describe and implement best practices for user administration SQL Server

 

DO NOT USE GUI. You will not receive points if you use GUI. Run code; provide selectable queries and screenshot of the results. You will lose points if you provide only screenshots of your queries.

 

1.        Create SQL Server login jdowf17

 

 

 

2.            Set default database for jdowf17 to USE AdventureWorks.

 

 

 

3.            Create user for login jdowf17 in database USE AdventureWorks.

 

 

 

4.            Connect to SQL Server as jdowf17. Try to select all rows from Person.Address table (USE AdventureWorks db). Explain results.

How many rows were returned?

 

 

5.            Provide details on how you allowed jdowf17 to select all rows from Person.Address table

6.            Add permissions for jdowf17 to read and create tables in USE AdventureWorks Production schema and Insert rows in created tables.

 

Your screenshots should be similar to one below

Instruction Files

Related Questions in computer science category