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
|
Download Printable PDF. VALID exam to help you PASS. |
 |