user in oracle

create user alfredo identified by alfredos_secret;
alter user alfredo account unlock;
grant create session to the_user;