RE: How to restrict user's access to R12 application

 

Here is the script lock all users except 'user1','user2' ..

 

---- Lock out apps users other than DBAs

spool lock_accounts;

update applsys.fnd_user

set end_date = (SYSDATE -1)

where creation_date >= to_date('200902','YYYYMM')  <- Enter next day
from the date of  your Instance was created  else it will lock all
default users 

and user_name not in ('SYSADMIN', 'user1','user2' , ...)

and  end_date is NULL

/

 

col USER_NAME format a30

select  user_name,START_DATE,end_date from applsys.fnd_user where
end_date is NULL order by START_DATE;

 

prompt verify the details above and issue a commit....

spool off;

 

       Thanks, 

         Jay

 

________________________________

From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of fraz baig
Sent: Thursday, February 12, 2009 12:06 PM
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: RE: How to restrict user's access to R12 application

 

There are many ways you can do this with a plsql script 
 or a dataload script can also be used 
thanks

________________________________

Date: Wed, 11 Feb 2009 23:02:09 -0800
From: imran_kiani@xxxxxxxxx
Subject: How to restrict user's access to R12 application
To: ora-apps-dba@xxxxxxxxxxxxx

Hii

How to restrict few users to access my  R12 (12.0.6) EBS applications
temporarily, as I dont want to get into the process of disabling or
re-setting the passwords because of having a large number of users. I
have R12 (12.0.6) configured in multi-node fashion under Redhat Linux
4.6 AS with 10gR2 database.

 

I shall be grateful for sharing the information.
 

Sincerely,

 

Imran Kiani

 

________________________________

Explore the seven wonders of the world Learn more!
<http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBR
E>

Other related posts: