oracle8.1.6
begin
acs.remove_user(
user_id => :user_id
);
end;
begin
person.del(
person_id => :person_id
);
end;
select user_id,
username,
authority_id,
first_names,
last_name,
first_names || ' ' || last_name as name,
email,
url,
screen_name,
priv_name,
priv_email,
email_verified_p,
email_bouncing_p,
no_alerts_until,
last_visit,
to_char(last_visit, 'YYYY-MM-DD HH24:MI:SS') as last_visit_ansi,
second_to_last_visit,
to_char(second_to_last_visit, 'YYYY-MM-DD HH24:MI:SS') as second_to_last_visit_ansi,
n_sessions,
password_question,
password_answer,
password_changed_date,
member_state,
rel_id,
trunc(sysdate - password_changed_date) as password_age_days,
creation_date,
creation_ip
from cc_users
where user_id = :user_id
select user_id,
username,
authority_id,
first_names,
last_name,
first_names || ' ' || last_name as name,
email,
url,
screen_name,
priv_name,
priv_email,
email_verified_p,
email_bouncing_p,
no_alerts_until,
last_visit,
to_char(last_visit, 'YYYY-MM-DD HH24:MI:SS') as last_visit_ansi,
second_to_last_visit,
to_char(second_to_last_visit, 'YYYY-MM-DD HH24:MI:SS') as second_to_last_visit_ansi,
n_sessions,
password_question,
password_answer,
password_changed_date,
member_state,
rel_id,
trunc(sysdate - password_changed_date) as password_age_days,
creation_date,
creation_ip
from cc_users
where authority_id = :authority_id
and lower(username) = lower(:username)