Role Ids were added to system.users in #81457.
In 22.2, once the migration is done and we're on V22_2SystemUsersIDColumnIsBackfilled version, we're guaranteed every user has an ID. Furthermore, in 23.1, we're guaranteed that all users have ids.
Eventually, we want to start using IDs to refer to users (ie for privilege checks) instead of usernames and support operations such as alter role rename.
We still have to migrate the following tables:
The system.role_members migration is PR is out #85928 and will wait for the 22.2 branch cut before merging.
The migrations should look like the migration done in #85845
Jira issue: CRDB-19140
Epic CRDB-19134
Role Ids were added to
system.usersin #81457.In 22.2, once the migration is done and we're on
V22_2SystemUsersIDColumnIsBackfilledversion, we're guaranteed every user has an ID. Furthermore, in 23.1, we're guaranteed that all users have ids.Eventually, we want to start using IDs to refer to users (ie for privilege checks) instead of usernames and support operations such as
alter role rename.We still have to migrate the following tables:
system.role_memberssystem.privilegessystem.database_role_settingssystem.web_sessionssystem.external_connectionsThe
system.role_membersmigration is PR is out #85928 and will wait for the 22.2 branch cut before merging.The migrations should look like the migration done in #85845
Jira issue: CRDB-19140
Epic CRDB-19134