Sample Header Ad - 728x90

How to set PostgreSQL's permission when migrate other database to it on AWS?

0 votes
1 answer
825 views
We want to migrate an Oracle DB to a PostgreSQL DB in RDS with DMS. There is an official guide for preparision in the PostgreSQL's DB: https://docs.aws.amazon.com/dms/latest/sbs/chap-oracle2postgresql.steps.configurepostgresql.html When I do with postgres user - 1 ALTER USER postgresql_dms_user WITH SUPERUSER; Got postgres=> ALTER USER postgresql_dms_user WITH SUPERUSER; ERROR: must be superuser to alter superusers When I do a grant to sct user, got - 2 postgres=> GRANT ALL ON SEQUENCES IN SCHEMA main TO postgresql_sct_user; ERROR: syntax error at or near "IN" Line 1: GRANT ALL ON SEQUENCES IN SCHEMA main TO postgresql_sct_user... --- About 1, AWS' Aurora PostgreSQL' postgres user isn't the superuser Role name | Group postgres | {rds_superuser} Then how to grant a superuser to a new user? About 2, I'm using PostgreSQL 12 version in the RDS, does the syntax not supported?
Asked by Miantian (177 rep)
Oct 5, 2021, 09:12 AM
Last activity: Oct 6, 2021, 01:20 AM