OraFAQ Forum: Server Administration » need guidelines to drop user in oracle

Home » RDBMS Server » Server Administration » need guidelines to drop user in oracle (oracle 10.2.0.3 and solaris 10)

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

need guidelines to drop user in oracle [message #389571]

Mon, 02 March 2009 12:43

kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville

Member

Hello experts,

i need to drop one user along with objects. i have some questions before drop the user.

what are the pre checks i need to perform.
what are the post check i need to perform after dropping user.

i am checking object status from dba_objects after dropping user. is it enough?

i am using following command to drop user with objects

drop user xxx cascade;

i have never drop user in the production database in the past. kindly provide some inputs.

Report message to a moderator

Re: need guidelines to drop user in oracle [message #389572 is a reply to message #389571]

Mon, 02 March 2009 12:47

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

what are the pre checks i need to perform.

Nothing.

Quote:

what are the post check i need to perform after dropping user.

Nothing.

Theorically you should know why you drop the user and what are the dependencies of its objects WITHOUT checking anything in the database.

Regards
Michel

Report message to a moderator

Re: need guidelines to drop user in oracle [message #389573 is a reply to message #389571]

Mon, 02 March 2009 12:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>what are the pre checks i need to perform.
You need to have current backups with tested & documented recovery procedures?

Report message to a moderator

Re: need guidelines to drop user in oracle [message #389578 is a reply to message #389573]

Mon, 02 March 2009 13:10

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Also, you MIGHT just want to lock the user and/or change the password and wait a week if someone screams.

Report message to a moderator

Re: need guidelines to drop user in oracle [message #389615 is a reply to message #389578]

Mon, 02 March 2009 22:59

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>what are the pre checks i need to perform.

Take backup for your schema.

>>what are the post check i need to perform after dropping user.

After dropping user; what your going to check?? Nothing.

>>i am checking object status from dba_objects after dropping user. is it enough?

Yes It's enough.

Report message to a moderator

Re: need guidelines to drop user in oracle [message #389618 is a reply to message #389571]

Mon, 02 March 2009 23:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You might want to check for INVALID objects before & after DROP.

Report message to a moderator

Previous Topic:	Tablespace error
Next Topic:	Database creation stopped

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 06:40:16 CDT 2024