A company uses TRUSTED CONTEXT "ERP1" and ROLE "ERP_ROLE" as a security mechanism to limit security exposure for an application. All the DB2 objects databases, table spaces, tables, indexes, views, plans and packages. have been created by that ROLE. The ROLE "ERP_ROLE" has been assigned to User ID "DBA01" in order to perform DBA related tasks. When the user "DBA01" leaves the company, the authorization ID is removed. Which of the following statements are correct? Select two answers.

A. None of these DB2 objects need to be recreated to re-grant the privileges.
B. The related plans and packages have to be recreated and the privileges re-granted.
C. When removing user "DBA01" privileges, none of these DB2 objects need to be dropped.
D. Only the related databases, table spaces, tables, indexes and views need to be recreated and the privileges re-granted.
E. To remove the privileges of user "DBA01" on these related plans and packages, they have to be dropped and as a result all associated privileges are revoked.

Ans : A,C