OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Oracle11i

Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle11i - Sys Admin

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle11i - Sys Admin [message #169852]

Sat, 29 April 2006 07:57

annacol
Messages: 9
Registered: April 2006
Location: Sri Lanka

Junior Member

Hi

I would like to knwo how to remove a user from oracle application. I knew how deactivate a responsibility assigned to a user but wants to know how to remove a user

Thanking you in advance

Anna

Report message to a moderator

Re: Oracle11i - Sys Admin [message #170061 is a reply to message #169852]

Mon, 01 May 2006 22:41

manwadkar
Messages: 104
Registered: September 2005
Location: Washington DC

Senior Member

You can not delete Oracle application user and also not supposed to. User's user_id propogates into multiple tables in Oracle apps and created_by and last_updated_by and also with as a transaction data. So it is not recommended to delete user. If you really want to delete it then can do it from backend. Before this you need to clean up referenced table to have consistent data.

Report message to a moderator

Re: Oracle11i - Sys Admin [message #170080 is a reply to message #169852]

Tue, 02 May 2006 00:43

tgs100
Messages: 66
Registered: July 2005
Location: Chennai, India

Member

Hi annacol,

You need to ask yourself, the purpose of deleting the user from oracle apps. If the purpose is solved by workaround procedure, why do you want to delete the user?

You can give "effective to" date in the user definition screen so that the user is deactivated. You can also deactivate the user by deactivating all the responsibilities.

Deleting the user thro' front end is not possible. Even though it is possible to delete the user thro' backend, it is not advisable to do so.

May be you can try deleting the user thro' backend in your test instance.

Razz

Sara

Report message to a moderator

Re: Oracle11i - Sys Admin [message #170527 is a reply to message #169852]

Thu, 04 May 2006 04:36

David.K.Dickson
Messages: 413
Registered: October 2005
Location: Surrey, England

Senior Member

I agree. You cannot delete a user through the forms, because the userid is recorded against any transactions the user has performed.

Instead of trying to delete the use, simply enter an Effective To Date on the "Users" form, on the right-hand side, half-way down. The user will then not be able to log on.

Cool

HTH

David

Report message to a moderator

Re: Oracle11i - Sys Admin [message #170650 is a reply to message #170527]

Thu, 04 May 2006 11:26

adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway

Senior Member

Also, is it not nice to have an overview of who had access to the system when? Even if the user never created or updated any record in the database, I think it still would not be a good idea to delete the user. It would certainly not be something that would endear yourself to your auditors. Wink

--
Aleksander

Report message to a moderator

Previous Topic:	unposted irems in Receivables
Next Topic:	Contracts Business Flow

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 13:53:29 CST 2024