As jmodic stated, the DBA_PROFILES view will list the avalable profiles to assign. The view DBA_USERS will list the profile name assigned to a user.

ALTER USER "username" PROFILE "profilename";


P.S. Management (users) is simple and easy (Point & Click) via the DBA STUDIO provided by Oracle vs. SQL.