Which term is assigned to the database user account?

Which term is assigned to the database user account?

• A. View Materialized
• B. Authentication
• C. Catalog
• D. Access Privileges

Answer: (D)

In a database, the term assigned to a user account refers to the rights that user has to perform actions on objects. These are called access privileges. They determine what operations the user can do (like SELECT, INSERT, UPDATE, DELETE) and on which objects (tables, views, schemas). Authentication is about verifying who the user is, not what they are allowed to do. Catalog is the metadata store that tracks information about database objects, and a materialized view is a stored query result—neither describes the user’s rights. So the correct concept for what the account is given to define its capabilities is access privileges.

In a database, the term assigned to a user account refers to the rights that user has to perform actions on objects. These are called access privileges. They determine what operations the user can do (like SELECT, INSERT, UPDATE, DELETE) and on which objects (tables, views, schemas). Authentication is about verifying who the user is, not what they are allowed to do. Catalog is the metadata store that tracks information about database objects, and a materialized view is a stored query result—neither describes the user’s rights. So the correct concept for what the account is given to define its capabilities is access privileges.