When a role is dropped, which role inherits ownership of objects owned by the dropped role?

The correct answer is B. The role above the dropped role in the RBAC hierarchy. When a role is dropped, ownership of all objects owned by the dropped role is transferred to the role that is directly above the dropped role in the role hierarchy. This is to ensure that there is always a single owner for each object in the system.

Data and Access Management

Question

Options

AThe SYSADMIN role
BThe role above the dropped role in the RBAC hierarchy
CThe role executing the command
DThe SECURITYADMIN role

How the community answered

(38 responses)

A
3% (1)
B
84% (32)
C
3% (1)
D
11% (4)

Explanation

When a role is dropped, ownership of all objects owned by the dropped role is transferred to the role that is directly above the dropped role in the role hierarchy. This is to ensure that there is always a single owner for each object in the system.

Topics

#DROP ROLE#ownership transfer#RBAC hierarchy#object ownership

Community Discussion

No community discussion yet for this question.

Full ADA-C01 Practice