GRANT SELECT UPDATE Designation ON Employee TO Amali Hiruni WITH-05021
GRANT SELECT, UPDATE(Designation) ON Employee TO Amali,Hiruni WITH GRANT OPTION;What does this SQL statement do?
This multiple choice question (MCQ) is related to the book/course
vu cs403 Database Management Systems.
It can also be found in
vu cs403 Final Term - Quiz No.8.
GRANT SELECT, UPDATE(Designation) ON Employee TO Amali,Hiruni WITH GRANT OPTION;What does this SQL statement do?
Grant permission to Amali,only to retrieve data from Employee table and grant permission to Hiruni, onlyto update the designation from Employee table.
Grant permission to Amali & Hiruni to retrieve data from Employee table
Grant permission to Hiruni in order to grant, select and update permission to Amali.
Grant permission to Amali and Hiruni to update all data except designation in Employee table
