Question: In the SQL management system, define a login account using your Given Name as the account name, which can be validated through the SQL authentication
In the SQL management system, define a login account using your Given Name as the account name, which can be validated through the SQL authentication mode and access the SQL Server. Then map this login account to a user account in the database Student in your Server. The user name is the same as the login account. Finally, grant this database user the authorities to select and update a table. Give the snapshots of using this user to do select query in the database student.
In the SQL management system, define a login account using your Given Name as the account name, which can be validated through the SQL authentication mode and access the SQL Server. Then map this login account to a user account in the database Student in your Server. The user name is the same as the login account. Finally, grant this database user the authorities to select and update a table. Give the snapshots of using this user to do select query in the database student.
this is the all the information you need...just make a login account and map it through user account in a database named student which you can do by (Create database student ) and grant them access like the question told! and take snapshot of them and just upload them as answer
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
