Question 440
A table is moved to a different schema and a team expects old namespace privileges to authorize it forever. How should the team validate that the problem is actually resolved?
Explanation
Correct Answer
Approved users keep access while former unrelated principals lose it. This is the most directly relevant verification because namespace hierarchy and inheritance affect effective access after object relocation. A concrete acceptance check is: Approved users keep access while former unrelated principals lose it. To reduce recurrence: Include effective-grant checks in table moves.
Incorrect Answers
Without metadata consumers cannot assess ownership and meaning reliably. Here the important technical distinction is that namespace hierarchy and inheritance affect effective access after object relocation.
Short names alone omit namespace and trust context in a multi-catalog estate. The reported failure instead depends on this fact: namespace hierarchy and inheritance affect effective access after object relocation.
Free-form tagging causes classification drift and inconsistent automation. That consideration does not remove the current constraint: namespace hierarchy and inheritance affect effective access after object relocation.