Hello,

I want to connect AWS rds to odoo I have configured it and the connection is okay but when I want to give supper user permission to my Postgres I am unable to give it.

Here is the user I gave him only created access

When I am trying to assign super user access I have the below message

on the access I've given, I can access the DB but can create a database. when i am trying to create a new database I have the access error 'Database creation error: permission denied for schema public'

The odoo.conf file:

[options]

; This is the password that allows database operations:

admin_passwd = odoo16

http_port = 8069

db_host = RDS(Endpoint)

db_port = 5432

db_name = False

db_user =  odoouser

db_password = odoouser

;db_sslmode=prefer

;db_template = template1

logfile = /var/log/odoo/odoo-server.log

addons_path=/odoo/odoo-server/addons,/odoo/custom/addons

proxy_mode = True

I also tried the below command, But nothing changed.

GRANT ALL ON SCHEMA public TO ;

Need urgent help. Thank you.