Which of the following is TRUE if this statement is executed later?

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;
A . This statement will succeed and DB2 INST3 will still be able to create in the database
B . This statement will succeed and DB2 INST3 only retains DATAACCESS privileges on the database
C . This statement will fail as CREATETAB is granted to two different roles and must be revoked at the
same time
D . This statement will succeed with a warning since CREATETAB cannot be totally revoked. DB2INST3
will retain both roles

View Answer

Answer: D