Home » RDBMS Server » Server Administration » Precautions before drop user (Oracle,11g,Unix)
Precautions before drop user [message #517773] Thu, 28 July 2011 02:18 Go to next message
Smith14
Messages: 38
Registered: July 2011
Location: India
Member
Hi all,

I want to drop some users which are no longer been used .What are the precautions
i need to take before i drop users? I have taken logical backup (Export) of users i want to drop.

Is there anything i missed out before i drop user?

Thank you
Re: Precautions before drop user [message #517776 is a reply to message #517773] Thu, 28 July 2011 02:37 Go to previous messageGo to next message
Michel Cadot
Messages: 58959
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Before droppping them and during say 2 weeks, lock the accounts and revoke all privileges granted on their objects.
If no one complains then you can drop them.

Regards
Michel
Re: Precautions before drop user [message #517783 is a reply to message #517776] Thu, 28 July 2011 04:31 Go to previous messageGo to next message
Smith14
Messages: 38
Registered: July 2011
Location: India
Member

Thank you Michel..
Re: Precautions before drop user [message #517907 is a reply to message #517783] Fri, 29 July 2011 07:15 Go to previous messageGo to next message
Roachcoach
Messages: 1200
Registered: May 2010
Location: UK
Senior Member
Its holiday season, 3 weeks may be safer Wink
Re: Precautions before drop user [message #517910 is a reply to message #517907] Fri, 29 July 2011 07:27 Go to previous message
ThomasG
Messages: 3099
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Just don't throw away the export before the next year-end-processing. We for example have a schema that is only used by the tax auditor once a year. Wink
Previous Topic: Resource Manager: instance caging
Next Topic: OLAP DML error "ORA-35571: The maximum number of load errors has occured." while executing
Goto Forum:
  


Current Time: Wed Sep 03 02:45:18 CDT 2014

Total time taken to generate the page: 0.09609 seconds