Review the permissions required to connect Data Integrity Suite to AWS Aurora PostgreSQL.
Note: Metadata extraction is available only with the Advanced Connectivity Bundle (ACB) entitlement.
Required database permissions
The database user requires the following privileges:
CONNECTon the target databaseUSAGEon all schemas to be catalogedSELECTon all tables and views to be cataloged- Read access to
pg_catalogsystem tables
Example grants:
GRANT CONNECT ON DATABASE mydb TO dis_user;
GRANT USAGE ON SCHEMA myschema TO dis_user;
GRANT SELECT ON ALL TABLES IN SCHEMA myschema TO dis_user;