OraFAQ Forum: Server Administration » Precautions before drop user

Home » RDBMS Server » Server Administration » Precautions before drop user (Oracle,11g,Unix)

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

Precautions before drop user [message #517773]

Thu, 28 July 2011 02:18

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

Report message to a moderator

Re: Precautions before drop user [message #517776 is a reply to message #517773]

Thu, 28 July 2011 02:37

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Precautions before drop user [message #517783 is a reply to message #517776]

Thu, 28 July 2011 04:31

Smith14
Messages: 38
Registered: July 2011
Location: India

Member

Thank you Michel..

Report message to a moderator

Re: Precautions before drop user [message #517907 is a reply to message #517783]

Fri, 29 July 2011 07:15

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Its holiday season, 3 weeks may be safer Wink

Report message to a moderator

Re: Precautions before drop user [message #517910 is a reply to message #517907]

Fri, 29 July 2011 07:27

ThomasG
Messages: 3212
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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 29 23:38:18 CDT 2025