Which type of privilege is being used?

An Administrator has set up security constraints on columns holding sensitive data through the use of profiles. A user, with an appropriate profile, then issues a select against this sensitive data.

Which type of privilege is being used?
A . Inherited
B . Ownership
C . Automatic
D . Assigned

View Answer

Answer: A

Explanation:

Inherited privileges are those that a user acquires based on their membership in a profile or role. In this case, the user has been assigned a profile that grants access to sensitive data, meaning the privilege to access that data is inherited through the profile.

Option B (Ownership) refers to the privileges that the creator (owner) of a database object has over that object, but in this case, the user is accessing data through a profile, not ownership.

Option C (Automatic) would suggest that the privilege is granted automatically without the need for an explicit assignment or inheritance, which doesn’t apply here because the privileges are coming from a profile.

Option D (Assigned) refers to direct privileges granted to a user individually, but in this scenario, the user is accessing data through a profile, which means the privileges are inherited rather than directly assigned.