Creating a Profile

SQL> select * from dba_profiles;

                To see the list of profiles.

SQL> desc dba_profiles;

SQL> select resource_name,resource_type,limit from dba_profiles;

SQL> create profile profile1 limit

                failed_login_attempts 2

                session_per_user 2;

SQL> select * from dba_profiles;

SQL> desc dba_users;

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

                To see which user is attached to which profile.