1.  creates a login ID named "CIS435_user1" with the password "P@ssword1"; (2) sets the default database for the login to the AdventureWorks2012 database; (3) creates a user named "CIS435_user1" for the login; and (4) assigns the user to the db_datareader role.

Answer rating: 100% (QA)

Creating a login ID setting the default database creating a user and assigning roles typically invol... View the full answer