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?
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.
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.
发布时间:2025-07-24 09:17:59