Which Transact-SQL statement should you run?

You are a database administrator for an organization. You must allow the members of the human resources department to add new employee records to the HR.Employees table. All members of the human resources department are assigned the HumanResources database only.

You need to ensure that members of the human resources department can add records to the table.

Which Transact-SQL statement should you run?
A . GRANT INSERT ON H
B . Employees to HumanResources
C . GRANT UPDATE ON H
D . Employees to HumanResources
E . GRANT REFERENCES ON SCHEMA :: HR to HumanResources
F . GRANT ALTER ON H
G . Employees to HumanResources

View Answer

Answer: A

Explanation:

To add records you would the INSERT permission.

References: https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-object-permissions­transact-sql