How can I create a new Admin User in Redshift without access to any SuperUser accounts

Question

I have accidentally removed the SUPER USER account that I use to run admin tasks with.  This is the only admin user for the Redshift cluster, apart from the default `rdsdb` user.

Logged in as this admin account - I ran the following statement:

```
ALTER USER {admin_user} NOCREATEUSER;
```

And now I cannot add new Super Users - as this admin user no longer has this permission.

So - Whats the best solution?  I do have snapshot backups from before my mistake, and I can restore one of those to another Cluster, but I would prefer to get back into the existing cluster if possible!

Answer

Only super users can create super users as described in the following document.  
https://docs.aws.amazon.com/redshift/latest/dg/r_superusers.html  
> You must be a superuser to create a superuser.

I think the only way to restore users is to restore Redshift from backup.

If this answer leads to a resolution, please approve the answer for the betterment of the community.

How can I create a new Admin User in Redshift without access to any SuperUser accounts

相關內容