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
