drop user usr1

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 )

--

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 )

--

syn: drop user username cascade

eg: drop user user1 cascade

tx paa

drop user user_name cascade;

This command really works..