QUESTION: 13

How can you tell what privileges on a table or view have been granted to a user? (Choose two.)

db2look with the x option
db2pd with the auth option
Query the SYSCAT.DBAUTH view
Query the SYSCAT.TABLES view
Query the SYSCAT.TABAUTH view

Answer(s): C,E

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;

This statement will succeed and DB2 INST3 will still be able to create in the database
This statement will succeed and DB2 INST3 only retains DATAACCESS privileges on the database
This statement will fail as CREATETAB is granted to two different roles and must be revoked at the same time
This statement will succeed with a warning since CREATETAB cannot be totally revoked. DB2INST3 will retain both roles

Answer(s): D

Reveal Solution Next Question

QUESTION: 15

Consider the following sequence of events:
Eddie grants SELECT WITH GRANT OPTION privilege to Mike.
Mike grants SELECT privilege to Jeff.
Eddie revokes SELECT privilege from Mike.
What will happen to Jeff's SELECT privilege?