Home » RDBMS Server » Security » How to delete a user?
How to delete a user? [message #111622] Fri, 18 March 2005 03:58 Go to next message
Messages: 135
Registered: January 2004
Location: Beijing,China
Senior Member
Please tell me the SQL statement to delete a user.
Re: How to delete a user? [message #111623 is a reply to message #111622] Fri, 18 March 2005 04:09 Go to previous message
Messages: 723
Registered: March 2005
Senior Member
DROP USER <username> [CASCADE]

Specify CASCADE to drop all objects in the user's schema before dropping the user.
You must specify this clause to drop a user if it's schema contains any objects.

Previous Topic: Re: User ID/ Password/ Host string for Oracle 10G (split from hijacked thread by bb)
Next Topic: How to change password of Sysdba
Goto Forum:

Current Time: Thu Sep 21 09:30:02 CDT 2023