Oracle Database User Profile

How to get details related to Oracle Database User Profile 

Get the Oracle User Profile detail 

set linesize 190

col username for a30

col profile for a30

 select username,profile from dba_users where username='&1';

Description related to Oracle DBA Profile table to get dba_profiles values.

desc dba_profiles;

 Name                                      Null?    Type

 ----------------------------------------- -------- ----------------------------

 PROFILE                                   NOT NULL VARCHAR2(128)

 RESOURCE_NAME                 NOT NULL VARCHAR2(32)

 RESOURCE_TYPE                                      VARCHAR2(8 CHAR)

 LIMIT                                              VARCHAR2(128 CHAR)

 COMMON                                             VARCHAR2(3 CHAR)

 INHERITED                                          VARCHAR2(3 CHAR)

 IMPLICIT                                           VARCHAR2(3 CHAR)

Get the Profile Details 

set linesize 190

col resource_name for a30

col resource_type for a30

col limit for a30

select resource_name,resource_type,limit from dba_profiles where profile='&1';

ALTER PROFILE default LIMIT PASSWORD_REUSE_MAX unlimited;

ALTER PROFILE default LIMIT PASSWORD_REUSE_TIME unlimited;

alter user &username identified by &passwd account unlock;