Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. Use a T-SQL statement to create a SQL Server-Authenticated login JSmith. In the creation statement set the password to InitPassword123 and configure so that
2. Use a T-SQL statement to create a SQL Server-Authenticated login "JSmith". In the creation statement set the password to "InitPassword123" and configure so that JSmith must change his/her password the first time the login is used.
3. Use a T-SQL statement to add JSmith as a user of CPD224Training database.
4. Add database user JSmith to the "db_datareader" database role in the CPD224Training database.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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