nerdexam
IBM

C2090-312 · Question #15

Row and column level security can be implemented using mask and permissions. Which two DB2 authorities are able to create a mask or permission? (Choose two.)

The correct answer is A. SECADM authority. D. SYSADM authority when SEPARATE_SECURITY=NO. See the full explanation below for the reasoning.

Question

Row and column level security can be implemented using mask and permissions. Which two DB2 authorities are able to create a mask or permission? (Choose two.)

Options

  • ASECADM authority.
  • BACCESSCTRL authority.
  • CDATAACCESS authority.
  • DSYSADM authority when SEPARATE_SECURITY=NO.
  • EThe owner of the object as he/she has that authority implicitly.

How the community answered

(65 responses)
  • A
    82% (53)
  • B
    3% (2)
  • C
    11% (7)
  • E
    5% (3)

Community Discussion

No community discussion yet for this question.

Full C2090-312 Practice