IBM
C2090-320 · Question #1
Consider the following scenario: User1 creates table USER1.TABLE1 in DATABASE1 User1 grants ALL PRIVILEGES on TABLE1 to User2 User2 grants ALL PRIVILEGES on TABLE1 to User3 User1 revokes ALL…
The correct answer is B. Yes. See the full explanation below for the reasoning.
Question
Consider the following scenario:
User1 creates table USER1.TABLE1 in DATABASE1 User1 grants ALL PRIVILEGES on TABLE1 to User2 User2 grants ALL PRIVILEGES on TABLE1 to User3 User1 revokes ALL PRIVILEGES on TABLE1 to User2 User3 has DBCTRL authority on DATABASE1 Is User3 able to retrieve rows from TABLE1?
Options
- ANo
- BYes
- CNo, if the revoke used INCLUDING DEPENDENT PRIVILEGES
- DYes, if User3 was granted DBCTRL prior to the creation of table USER1.TABLE1
How the community answered
(47 responses)- A6% (3)
- B74% (35)
- C4% (2)
- D15% (7)
Community Discussion
No community discussion yet for this question.