A company is going to use an Amazon Aurora PostgreSQL DB cluster for an application backend. The DB cluster contains some tables with sensitive data. A Database Specialist needs to control the access privileges at the table level. How can the Database Specialist meet these requirements?
A) Use AWS IAM database authentication and restrict access to the tables using an IAM policy.
B) Configure the rules in a NACL to restrict outbound traffic from the Aurora DB cluster.
C) Execute GRANT and REVOKE commands that restrict access to the tables containing sensitive data.
D) Define access privileges to the tables containing sensitive data in the pg_hba.conf file.

Question

Quizplus · Accepted Answer

The GRANT and REVOKE commands in PostgreSQL are used to control access privileges at the table level, allowing the Database Specialist to specify which users can access specific tables.

A Company Is Going to Use an Amazon Aurora PostgreSQL