Hi,
The root cause of account lockouts is incorrect credentials. Incorrect credentials will cause unsuccessful login, then the user's account get locked.
So, a user who is not in the group will be denied to access to RDS but the account will not be locked if there is no password error during login attempt.
Thanks,
Eleven