Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
- 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Creating a login ID setting the default database creating a user and assigning roles typically invol...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started