Explain what is happening in the code sample below.GRANT EXEC ON usp_StudentLogIn TO StudentRoleCREATE USER StudentUser FOR LOGIN StudentLoginEXEC sys.sp_addrolemember StudentRole, StudentUser
What will be an ideal response?
The first command grants permission to execute a stored procedure to the StudentRole. The second command creates a new user based on the student login. The final command executes a system stored procedure that adds the new user to the role.
You might also like to view...
Profits or losses incurred by an organization are represented in its
A. income statement. B. expense budget. C. ratio analysis. D. capital expenditures budget. E. balance sheet.
A(n)___________is a form sent by the seller to the buyer as evidence of a sale
Fill in the blank(s) with correct word
The concept of democracy is based on the belief that each individual has the right and duty to fully participate in social and political decision making.
Answer the following statement true (T) or false (F)
Use the direct approach to communicate bad news about your organization if the audience has already heard about the situation from another source
Indicate whether the statement is true or false