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!

Report message to a moderator

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.

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Oct 01 03:37:30 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.