Drop user [message #56482] |
Thu, 03 April 2003 02:37 |
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 |
|
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
|
|
|