A table called DEPARTMENT has the following columns:
DEPT_ID
DEPT_NAME
MANAGER
Which of the following statements will ONLY allow user USER1 to modify the DEPT_NAME
column?
A.
GRANT ALTER ON TABLE department TO user1
B.
GRANT ALTER (dept_name) ON TABLE department TO user1
C.
GRANT UPDATE ON TABLE department TO user1
D.
GRANT UPDATE (dept_name) ON TABLE department TO user1
D is correct option
0
0
grant INSERT and UPDATE privileges at a column level:
GRANT INSERT (salary) ON persons to userName;
0
0