Aliyun ADB PostgreSQL
Please follow the instructions below to successfully add and use Aliyun ADB PostgreSQL database in TapData.
Supported Versions
6.0
As a Source
GRANT SELECT ON ALL TABLES IN SCHEMA <schemaname> TO <username>;
The above is a basic setting of permissions. Actual scenarios may be more complex.
As a Target
GRANT INSERT, UPDATE, DELETE, TRUNCATE ON ALL TABLES IN SCHEMA <schemaname> TO <username>;
The above is a basic setting of permissions. Actual scenarios may be more complex.