Score:0

Only rdsadmin account on AWS RDS with full master permissions

br flag

Good afternoon all,

I'm hoping someone is able to help with the following.

On our main live database it's just been brought to our attention that we need to be able to kill user processes that are sometimes stuck running on our database, in order to do this I need to have the ProcessAdmin role. When I try and login with the highest privilege account on our database (other than rdsadmin, but on further research it seems this account cannot be used and is for AWS services only) it says access denied when trying to give any of the super permission sets.

I'm now worried that there was potentially another God like master account that has somehow been deleted, although not sure how this would've been possible when all the other accounts have lower permission.

Just to give a rough idea, these are the permissions our highest accounts have: account permissions

And here is the permission set of the rdsadmin: rdsadmin permission

If anyone is able to help with this, will be highly appreciated.

Thanks!

Tim avatar
gp flag
Tim
To clarify - when you try this using the RDS master admin password that is set when you create the database, does this work?
Score:0
ms flag

I know this is 4 months old but if you are just looking at killing processes then all you have to do is use CALL mysql.rds_kill(xxx) where xxx is the process number. You can do that with an admin equiv account you setup.

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.