1Z0-071 practice question 31 of 35

Examine thee statements which execute successfully: CREATE USER finance IDENTIFIED BY pwfin; CREATE USER fin manager IDENTIETED BY pwmgr; CREATE USER fin. Clerk IDENTIFIED BY pwclerk; GRANT CREATE SESSON 20 finance, fin clerk; GRANT SELECT ON scott. Emp To finance WITH GRANT OPTION; CONNECT finance/pwfin GRANT SELECT ON scott. emp To fin_ _clerk; Which two are true?

Full set: 326 questions
Answer options
A: Dropping user FINANCE will automatically revoke SELECT on SCOTT. EMP from user FIN _ CLERK Correct answer
B: Revoking SELECT on SCOTT. EMP from user FINANCE will also revoke the privilege from user FIN_ CLERK. Correct answer
C: User FINANCE can grant CREATE SESSION to user FIN MANAGER.
D: User FIN CLERK can grant SELECT on SCORT, ENP to user FIN MANAGER.
E: User FINANCE is unable to grant ALL on SCOTT.ENP to FIN MANAGER.
Correct Answer:
A. Dropping user FINANCE will automatically revoke SELECT on SCOTT. EMP from user FIN _ CLERK; B. Revoking SELECT on SCOTT. EMP from user FINANCE will also revoke the privilege from user FIN_ CLERK.
Explanation

When a privilege is granted WITH GRANT OPTION, the grantee can grant that privilege to others. However, Oracle implements a dependency chain. If the original grantee (FINANCE) is dropped or has the privilege revoked, all dependent grants are automatically revoked. This cascading revocation ensures security integrity by preventing orphaned privileges.

Why Incorrect

C. FINANCE only received CREATE SESSION without GRANT OPTION, so cannot grant it to others.
D. FINCLERK received SELECT without GRANT OPTION, so cannot grant it to FINMANAGER.
E. FINANCE cannot grant ALL privileges because it only has SELECT privilege on SCOTT.EMP.

References

1. Oracle Database SQL Language Reference 19c, "GRANT Statement", Section on WITH GRANT OPTION behavior

2. Oracle Database Security Guide 19c, Chapter 4 "Managing User Privileges", Cascade Effects of Revoking Privileges

3. Oracle Database Administrator's Guide 19c, "Managing Users and Securing the Database", Privilege Dependencies section

Scroll to Top