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
rushing
Messages: 135
Registered: January 2004
Location: Beijing,China
Senior Member
Please tell me the SQL statement to delete a user.
Thanks!
Re: How to delete a user? [message #111623 is a reply to message #111622] Fri, 18 March 2005 04:09 Go to previous message
dmitry.nikiforov
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.

Rgds.
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 Mar 28 14:26:10 CDT 2024