OCP CBT Question 599

Please solve the following question.

You have created a role APP_ROLE and granted it to user DEV_USER. You want APP_ROLE to be enabled automatically when DEV_USER logs in. Which command should you use?

sql CREATE ROLE app_role; GRANT SELECT ON hr.employees TO app_role; GRANT app_role TO dev_user;

ALTER USER dev_user DEFAULT ROLE ALL;

ALTER USER dev_user DEFAULT ROLE app_role;

SET ROLE app_role;

GRANT SET ROLE TO dev_user;