col profile  for a10
col limit    for a10
col username for a20
select username, profile, resource_name, resource_type, limit
         from dba_users
 natural join dba_profiles
   where username         = 'USR_HAJO'
     and resource_name like 'CPU%'
   order by 1, 2, 3;
_____________________________________________________________________________________________________________________
_____________________________________________________________________________________________________________________

SAMPLE SCENARIO
===============
-- CREATE THE USER
drop   user usr_hajo cascade;
create user usr_hajo identified by hajo default tablespace users;

grant connect, resource        to usr_hajo;
grant select on sys.dba_tables to usr_hajo;


-- CREATE THE PROFILE
create profile prf_hajo
limit connect_time 60
;
select profile, resource_name, resource_type, limit from dba_profiles where profile = 'PRF_HAJO';


-- ASSIGN THE PROFILE TO THE USER
alter user usr_hajo profile prf_hajo;
select username, profile from dba_users where username = 'USR_HAJO';


-- ALTER THE PROFILE
alter profile prf_hajo limit
cpu_per_call      3600
cpu_per_session   1
;
select profile, resource_name, resource_type, limit from dba_profiles where profile = 'PRF_HAJO';


-- DROP THE PROFILE WITH CASCADE - (RESETS ALL USERS WITH THIS PROFILE TO PROFILE 'DEFAULT')
select username, profile from dba_users where username = 'USR_HAJO';
drop profile prf_hajo cascade;


-- DROP THE USER
select username, profile from dba_users where username = 'USR_HAJO';
drop user usr_hajo cascade;


-- CREATE JUST A PROFILE WITHOUT RESTRICTIONS
create profile prf_hajo limit;
select profile, resource_name, resource_type, limit from dba_profiles where profile = 'PRF_HAJO';
drop profile prf_hajo;
_____________________________________________________________________________________________________________________
_____________________________________________________________________________________________________________________

/*---------------------------------------------------------------
AVAILABLE RESOURCES:
====================
COMPOSITE_LIMIT
CONNECT_TIME
CPU_PER_CALL
CPU_PER_SESSION
FAILED_LOGIN_ATTEMPTS
IDLE_TIME
LOGICAL_READS_PER_CALL
LOGICAL_READS_PER_SESSION
PASSWORD_GRACE_TIME
PASSWORD_LIFE_TIME
PASSWORD_LOCK_TIME
PASSWORD_REUSE_MAX
PASSWORD_REUSE_TIME
PASSWORD_VERIFY_FUNCTION
PRIVATE_SGA
SESSIONS_PER_USER
---------------------------------------------------------------*/