I have request and i would like assistance. I have created this query:
select username, profile, r.GRANTED_ROLE, decode(account_status,'OPEN','ACTIVE','EXPIRED','EXPIRED','INACTIVE') "ACCOUNT STATUS",created,
s.PTIME "Password Change Time", last_login
from dba_users, dba_role_privs r, sys.user$ s
where username=r.grantee(+)
and username=s.NAME
order by 1;
So i am ok with it, but i wanted to know how can i join personal database accounts with some of Oracle’s HRMS table in order to get for them details like email, employee_id etc.