What type of privilege is assigned by granting rights to a specific object?

The type of privilege assigned by granting rights to a specific object is known as Explicit Privilege. When a user or a role receives an explicit privilege, it means that specific permissions are granted directly to them for a particular database object, such as a table or a view. This grants the holder the ability to perform defined actions (like SELECT, INSERT, or DELETE) specifically on that object.

This concept is fundamental in Teradata's security model, where managing who has access to what data is critical for compliance and data integrity. By using explicit privileges, a database administrator can ensure that users have the necessary permissions tailored to their roles, thereby enforcing security policies effectively at a granular level.

In contrast, inherited privileges are permissions passed down from a higher-level role or object which do not require directly granting access to the user. Implicit privileges normally refer to automatic rights that a user might have due to their roles or position, and access privilege is a more general term that might not specifically refer to explicit assignment. Therefore, the notion of explicit privilege pertains directly to the act of granting specific rights to defined users or roles regarding particular objects.