Exam 1z0-071 All QuestionsBrowse all questions from this exam
Go to Exam
Question 13

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?

    Correct Answer: C

    To allow user ANDREW to modify the TITLE and ADDRESS columns of the CUSTOMERS table and to grant that permission to other users, you need to use the GRANT statement with the WITH GRANT OPTION clause. This clause allows the grantee (ANDREW) to pass on the privileges to other users. The correct syntax for specifying specific columns is to list them within parentheses following the UPDATE keyword. Therefore, the correct statement is: GRANT UPDATE (title, address) ON customers TO andrew WITH GRANT OPTION.

Discussion
nejakOption: C

C is correct: WITH GRANT OPTION is necessary in this case

MIGHTYSTUNNERSOption: E

E is also correct

tawa_z58Option: C

C is correct

a947739Option: C

C is correct

alelejaja

Why is E not correct?

NSilvaOption: C

Whats the difference between C & E ? C. GRANT UPDATE (title, address) ON customers TO andrew WITH GRANT OPTION; E. GRANT UPDATE ON customers.title, customers.address TO andrew WITH GRANT OPTION;

Lee_jong_sukOption: C

C is correct! WITH GRANT OPTION now the user ANDREW can give grants to other users. GRANT UPDATE(TITLE) ON CUSTOMERS TO HR; If REVOKE UPDATE(TITLE,ADDRESS) ON CUSTOMERS FROM ANDREW is executed then eventually HR will also lose the grants.

Chandra1104Option: C

C is correct. The owner of an object can grant it to another user by specifying the WITH GRANT OPTION clause in the GRANT statement. In this case, the new grantee can then grant the same level of access to other users or roles. Here are three points to keep in mind about the WITH GRANT OPTION clause: https://www.oreilly.com/library/view/oracle-database-administration/1565925165/ch06s01s05s01.html#:~:text=The%20owner%20of%20an%20object,to%20other%20users%20or%20roles.