nerdexam
IBM

C2090-320 · Question #4

Which of the following actions can you take in order to prevent users from obtaining implicit privileges as a result of object ownership?

The correct answer is A. Create the object in a trusted context that is defined with the ROLE AS OBJECT OWNER AND. See the full explanation below for the reasoning.

Question

Which of the following actions can you take in order to prevent users from obtaining implicit privileges as a result of object ownership?

Options

  • ACreate the object in a trusted context that is defined with the ROLE AS OBJECT OWNER AND
  • BCreate the object after activating the SEPARATE_SECURITY=YES DSNZPARM
  • CLet somebody with SYSCTRL authority create the object
  • DCreate the object after activating an audit policy that will apply to the table that you are about to

How the community answered

(51 responses)
  • A
    75% (38)
  • B
    4% (2)
  • C
    14% (7)
  • D
    8% (4)

Community Discussion

No community discussion yet for this question.

Full C2090-320 Practice