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;
C is correct (GRANT option is for object privileges):
GRANT UPDATE (title, address) ON customers TO andrew WITH GRANT OPTION
E is not correct (ADMIN option is for system privileges):
GRANT UPDATE (title, address) ON customers TO andrew WITH ADMIN OPTION
gives the error ORA-00993: missing GRANT keyword.
C is the correct answer.
https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/GRANT.html#GUID-20B4E2C0-A7F8-4BC8-A5E8-BE61BDC41AC3__I2126048
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;
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.
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.
This section is not available anymore. Please use the main Exam Page.1z0-071 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
nejak
Highly Voted 2 years, 9 months agohighwater
Most Recent 4 months ago15eeda4
6 months, 2 weeks agobraintop
8 months, 1 week agokay000001
8 months, 3 weeks agoDrexan
9 months agoa947739
1 year agoalelejaja
1 year, 2 months agoMIGHTYSTUNNERS
1 year, 2 months agoNSilva
1 year, 3 months agoLee_jong_suk
1 year, 7 months agoChandra1104
2 years, 4 months agotawa_z58
2 years, 6 months ago