Your Doorstep to the Temple of Oracle

Oracle EBS

how to drop/Delete an application user

Posted by appsdba11i on May 14, 2011

Hi Folks

I am going to give some information about how to drop/deleting application user

We cannot delete a frontend user due to security reason.deleting cause some problem to the application.. If u want to delete the frontend user then deavtivate or enddate the user..

Methods to End-date application User..

Method 1
—————
Login to Oracle Applications – Select the System Administrator responsibility – Security – User – Define – Query  the user name – then you can give end date in the Effectives Date To column.

Method 2:
=======

Enddating user by sqlplus

1) backup fnd_user

SQL>CREATE TABLE FND_USER_BKP AS SELECT * FROM FND_USER;
2) The following SQL*Plus statement may be run from the APPS account:

SQL>update fnd_user set end_date=’14-jUN-2011′ where user_name like ‘%desired_ser_NAME%’;

NOTE

Modifying tables without the use of the Oracle Forms interface is NOT SUPPORTED.

Reference
How to Change the END_DATE for Applications Users through SQL*Plus [ID 1039608.6]

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: