4) Using Oracle ALTER USER statement to set the default profile for a user. This statement returns the profile of the user dolphin : SELECT username, profile FROM dba_users WHERE username ='DOLPHIN'; When you create a new user without specifying a profile, Oracle will assign the DEFAULT profile to the user.