You need to allow user ANDREW to:1. Modify the TITLE and ADDRESS columns of your CUSTOMERS table.2. GRANT that permissio

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You need to allow user ANDREW to:1. Modify the TITLE and ADDRESS columns of your CUSTOMERS table.2. GRANT that permissio

Post by answerhappygod »

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;
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply