What is the correct statement for the following query?
Give Manager UPDATE on column salary of Staff

Question

What is the correct statement for the following query? 
 Give Manager UPDATE on column salary of Staff

Accepted Answer

GRANT UPDATE (salary) 
 ON Staff 
 TO Manager;

Answer

GRANT UPDATE 
 ON Staff 
 TO PUBLIC WITH GRANT OPTION;

Answer

GRANT SELECT (salary) 
 ON Staff 
 TO Manager;

Answer

GRANT UPDATE 
 ON Staff 
 TO Manager WITH GRANT OPTION;

Crowdly