You need to allow user ANDREW to:1. Modify the TITLE and ADDRESS columns of your CUSTOMERS table.2. GRANT that permissio
Posted: Sun Jun 11, 2023 3:54 pm
You need to allow user ANDREW to:1. Modify the TITLE and ADDRESS columns of your CUSTOMERS table.2. GRANT that permission to other users.Which statement will do this?
A. GRANT UPDATE ON customers.title, customers.address TO andrew;
B. GRANT UPDATE (title, address) ON customers TO andrew;
C. GRANT UPDATE (title, address) ON customers TO andrew WITH GRANT OPTION;
D. GRANT UPDATE ON customers.title, customers.address TO andrew WITH ADMIN OPTION; E. GRANT UPDATE ON customers.title, customers.address TO andrew WITH GRANT OPTION; F. GRANT UPDATE (title, address) ON customers TO andrew WITH ADMIN OPTION;
A. GRANT UPDATE ON customers.title, customers.address TO andrew;
B. GRANT UPDATE (title, address) ON customers TO andrew;
C. GRANT UPDATE (title, address) ON customers TO andrew WITH GRANT OPTION;
D. GRANT UPDATE ON customers.title, customers.address TO andrew WITH ADMIN OPTION; E. GRANT UPDATE ON customers.title, customers.address TO andrew WITH GRANT OPTION; F. GRANT UPDATE (title, address) ON customers TO andrew WITH ADMIN OPTION;