Home » RDBMS Server » Server Administration » Drop user
Drop user [message #56482] Thu, 03 April 2003 02:37 Go to next message
Manish tiwari
Messages: 6
Registered: April 2003
Junior Member
1.Can we drop the user without using "CASCADE" clause .
If no then why is it must to use "CASCADE" clause with drop user statement .
Re: Drop user [message #56484 is a reply to message #56482] Thu, 03 April 2003 03:07 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
No, it is not mandatory to add "CASCADE", if you choose not to add it, the schema needs to be clean. This means that the user mustn't have a single object.

A more thourough explanation can be found here.

HTH,
MHE
Previous Topic: Display procedure contents
Next Topic: ORA-03114 when installing 8.1.7
Goto Forum:
  


Current Time: Sat Dec 28 23:37:39 CST 2024