If you do an "alter user userA default role none;" any role granted to userA will have a default default_role of "NO" from now on until you do a "alter user userA default role all;". I want to globally see what my user setting is for each and every user on the DB but but do not know what view/table to turn to to see this. I am not talking about the dba_role_privs view. This view is only showing me for what has been granted and this does not show the setting for the user. Please help.