Oracle: DEFROLE$

sys.defrole$ stores a user's default roles.

If no entry is found for a user, all roles assigned to that user are default roles (i.e. the efect of alter user XYZ default roles ALL is to clear all records for XYZ from defrole$.