SELECT * FROM DBA_PROFILES
WHERE RESOURCE_NAME='PASSWORD_LIFE_TIME';
--WHERE PROFILE = 'SISTEMA';

ALTER USER SYSDBPOWERCENTERFIES PROFILE SISTEMA;

SELECT * FROM DBA_USERS WHERE USERNAME = 'SYSDBPOWERCENTERFIES';
---------------------------------------------------------
--script create
select 'CREATE USER "' || s.NAME ||   DECODE(s.PASSWORD,'EXTERNAL','" identified EXTERNALLY','" identified by values ''' || s.PASSWORD || '''') ||' DEFAULT TABLESPACE '|| u.DEFAULT_TABLESPACE ||' TEMPORARY TABLESPACE '||u.TEMPORARY_TABLESPACE ||' PROFILE '||u.PROFILE ||';' as COMMAND_1 from   sys.USER$ s, DBA_USERS u
where  NAME=USERNAME AND NAME LIKE ('SYSDBPLANOCARREIRA');

-- alterar
alter  USER "SYSDBPLANOCARREIRA" identified by values 'D62A12CC705940D2'

hostgator