Solved

Auding FND_USERS for new created accounts and assigned responsibilities

Posted on 2006-06-22
8
733 Views
Last Modified: 2008-01-09
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.
0
Comment
Question by:kingno1
  • 4
  • 2
8 Comments
 
LVL 19

Expert Comment

by:actonwang
Comment Utility
all user account:

select user_id,user_name
from dba_users
where trunc(created) between to_date('10/01/2005','MM/DD/YYYY') and to_date('06/21/2006','MM/DD/YYYY');
0
 
LVL 19

Expert Comment

by:actonwang
Comment Utility
>>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>;
0
 

Author Comment

by:kingno1
Comment Utility
Hi, I am talking about Oracle Apps..
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:kingno1
Comment Utility
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.responsibility_id and  trunc(a.last_update_date) between to_date('10/01/2005','MM/DD/YYYY') and to_date('06/21/2006','MM/DD/YYYY') order by description, last_update_date
0
 
LVL 19

Expert Comment

by:actonwang
Comment Utility
here you go ...
0
 
LVL 19

Expert Comment

by:actonwang
Comment Utility
>>Oracle 11i APPS

i c.
0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
Comment Utility
PAQed with points refunded (100)

DarthMod
Community Support Moderator
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now