Vytvořit profil
create profile "NO_EXPIRE" limit cpu_per_session UNLIMITED cpu_per_call UNLIMITED connect_time UNLIMITED idle_time UNLIMITED sessions_per_user UNLIMITED logical_reads_per_session UNLIMITED logical_reads_per_call UNLIMITED private_sga UNLIMITED composite_limit UNLIMITED password_life_time UNLIMITED password_grace_time UNLIMITED password_reuse_max UNLIMITED;
Přiřadit profil uživateli
alter user "DBA" profile "NO_EXPIRE";