kingno1
asked on
Auding FND_USERS for new created accounts and assigned responsibilities
Hello, I want to create a report on user accounts created in Oracle 11i APPS that are created frm 10/01/2005 to 06/21/2006. Also, any user responsibilities that are assigned during that time frame. Please help.
>>any user responsibilities
if you are talking about privileges, then, you need to look at:
dba_tab_privs
dba_col_privs
dba_role_privs
dba_sys_privs
for example for all system privileges directly assigned to the user:
select privilege
from dba_sys_privs
where grantee = <user name>;
if you are talking about privileges, then, you need to look at:
dba_tab_privs
dba_col_privs
dba_role_privs
dba_sys_privs
for example for all system privileges directly assigned to the user:
select privilege
from dba_sys_privs
where grantee = <user name>;
ASKER
Hi, I am talking about Oracle Apps..
ASKER
tHANKS FOR THE REPLY..i FIGURED IT OUT..hERE IT IS JUST IN CASE..
select a.user_id, b.USER_NAME, b.DESCRIPTION, c.responsibility_key, a.last_update_date from apps.fnd_user_resp_groups_ direct a, applsys.fnd_user b, applsys.fnd_responsibility c where a.user_id=b.user_id and a.responsibility_id=c.resp onsibility _id and trunc(a.last_update_date) between to_date('10/01/2005','MM/D D/YYYY') and to_date('06/21/2006','MM/D D/YYYY') order by description, last_update_date
select a.user_id, b.USER_NAME, b.DESCRIPTION, c.responsibility_key, a.last_update_date from apps.fnd_user_resp_groups_
here you go ...
>>Oracle 11i APPS
i c.
i c.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
select user_id,user_name
from dba_users
where trunc(created) between to_date('10/01/2005','MM/D