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

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!

主题

分析

标签

Amazon Redshift

语言

English

rePost-User-4411835

已提问 1 年前1736 查看次数

1 回答

最新
投票最多
评论最多

这些答案有用吗？为正确答案投票，以帮助社区从您的知识中受益。

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.

专家

Riku_Kobayashi

已回答 1 年前

rePost-User-4411835
1 年前
Thanks - yes, I know that only super users can create other super users from the Docs. I was wondering if it might be possible to restore the underlying users tables / permissions without restoring to a new Cluster...

Or perhaps - can AWS Support add a new user in for me / fix this issue from their side?
Riku_Kobayashi 专家
1 年前
You can check with AWS support, but I don't think AWS support will create it for you, as user management is solely the responsibility of the AWS user.

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

相关内容