Yeah, that won’t work as you have it.
The only way you could get that to work would be if you defined the RowID column in your Users table as the Role column in your User Profiles configuration. But I’m not even sure if Glide will allow that.
It does however sound like what you need is to be using Roles as Row Owners. Have a read of the below, it might help to clarify how this can be configured.