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!

주제

분석

태그

아마존 Redshift

언어

English

rePost-User-4411835

질문됨 일 년 전1739회 조회

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

답변함 일 년 전

rePost-User-4411835
일 년 전
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 전문가
일 년 전
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

관련 콘텐츠