We are switching all users to use Google Authentication instead of mydbr authentication.
I had the idea that I could easily switch the users access rights to the new google user with a simple update statement:
update mydbr_reports_priv set username = 'newgoogleidusername' where username = 'oldmydbrusername';
This however doesn't work, and now I cannot give permissions at all to the new user in mydbr.
Is there some kind of caching or other mechanism that is preventing me from doing this?