The following statements are executed:
GRANT CREATETAB, DATAACCESS, ON DATABASE TO ROLE role A;
GRANT CREATETAB, BINDADD ON DATABASE TO ROLE role B;
GRANT ROLE role A to USER db2inst3;
GRANT ROLE role B to USER db2inst3;
Which of the following is TRUE if this statement is executed later?
REVOKE ROLE roleB FROM USER db2inst3;
When the role roleB is revoked from the user db2inst3, db2inst3 will lose the CREATETAB and BINDADD privileges assigned through roleB. However, since db2inst3 also has the role roleA, which includes the CREATETAB and DATAACCESS privileges, db2inst3 will still retain the CREATETAB privilege. Therefore, the statement will succeed and db2inst3 will still be able to create in the database.
The good answer is A. This statement will succeed and DB2 INST3 will still be able to create in the database With DB2, you do not have warning when you run revoker query.
I agree, the most suitable answer is A.
A. This statement will succeed and DB2 INST3 will still be able to create in the database ONE COMMAND cannot revoke both roles privilege's, as the are set of roles.