Altering a Profile

SQL> alter user venu profile profile1;

SQL> select username,profile from dba_users where username='VENU';

SQL> desc dba_profiles;

SQL> select * from dba_profiles where profile='PROFILE1';