Examine these statements which execute successfully:
Which two are true? (Choose two.)
Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 122
Correct Answer: A, D
User FIN_CLERK can grant SELECT on SCOTT.EMP to user FIN_MANAGER because user FIN_CLERK was granted the SELECT privilege on SCOTT.EMP by user FINANCE, who had the GRANT OPTION. This allows user FIN_CLERK to further grant the privilege to other users. Revoking the SELECT privilege on SCOTT.EMP from user FINANCE will also revoke the privilege from user FIN_CLERK. When a privilege is revoked from a user who has been granted it with the GRANT OPTION, and that user has further granted the privilege to others, those grants are also revoked.
Discussion
SantiBZ_07032022_1744Options: BD
BDE. B is right, because dropping a user implies to REVOKE all OBJECT PRIVILEGES granted by this user. Pay attention in the difference between object privileges and system privileges. System privileges must be revoked directly from user who has them.
jm9999Options: BD
When I tested this one, BD were true and E returned grant succeeded. However when I tested to see if those table privileges had actually been granted by E, the recipient had none of those abilities.
mrcsp
Specify ALL to grant all the privileges for the object that you have been granted with the GRANT OPTION.
MorticiaAAddamsOptions: DE
This is from official Oracle course: "If a user leaves the company and you revoke his or her privileges, you must re-grant any privileges that this user granted to other users. If you drop the user account without revoking privileges from it, the system privileges granted by this user to other users are not affected by this action."
Misi_Oracle
That’s the keyword. System privileges are not revoked. For object privileges, they are revoked if the user that grant it were dropped
maymanOptions: AD
A, D A. User FIN_CLERK can grant SELECT on SCOTT.EMP to user FIN_MANAGER - This is true because user FINANCE has been granted SELECT privilege on SCOTT.EMP with the GRANT OPTION, and user FINANCE subsequently granted SELECT on SCOTT.EMP to user FIN_CLERK. The GRANT OPTION allows the privilege to be further granted to other users. D. Revoking SELECT on SCOTT.EMP from user FINANCE will also revoke the privilege from user FIN_CLERK - This is true because when a privilege is revoked from a user who was granted the privilege with the GRANT OPTION, and who subsequently granted that privilege to other users, then the privilege is also revoked from the other users.
dexdinh91
why E is not correct?
mrcsp
Clearly a bad written alternative, GRANT ALL can be issued, but will transfer only the SELECT privilege. So is GRANT ALL in the alternative being capable of issue a GRANT ALL or to actually grant all privileges?