How to delete an Oracle Applications User?

Showing Answers 1 - 6 of 6 Answers

Subra Kondaveeti

  • Nov 1st, 2005
 

drop user usr1

  Was this answer useful?  Yes

svs_raja

  • Nov 7th, 2005
 

It can be done two ways:

1. To inactivate/lock by the following navigation:(But not deleted)

Login to Oracle Applications - Select the System Administrator responsibility - Security - User - Define - Query with the user name - then you can give end date in the "Effectives Date To" column.

2. You can delete through backend but it will be conflicted:

(delete the row in FND_USER table )

--

  Was this answer useful?  Yes

vipulravi sneha

  • Nov 21st, 2005
 

bck end not recomended...

Velusamy Raja Wrote:

It can be done two ways:

1. To inactivate/lock by the following navigation:(But not deleted)

Login to Oracle Applications - Select the System Administrator responsibility - Security - User - Define - Query with the user name - then you can give end date in the "Effectives Date To" column.

2. You can delete through backend but it will be conflicted:

(delete the row in FND_USER table )

--


  Was this answer useful?  Yes

sanjeev AV

  • Feb 27th, 2006
 

syn: drop user username cascade

eg: drop user user1 cascade

  Was this answer useful?  Yes

ram vara prasad

  • Mar 9th, 2006
 

tx paa,

         drop user user_name cascade;

           This command really works..

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions