Home » RDBMS Server » Security » how to delete the users name
how to delete the users name [message #159630] Mon, 20 February 2006 12:32 Go to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
hello sir
i like to know what is the syntax to delete the users name
Re: how to delete the users name [message #159636 is a reply to message #159630] Mon, 20 February 2006 12:59 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
SQL> DROP USER _the_user CASCADE;


Cascade is optional. This will drop all the user's objects prior to the drop of the user itself.

MHE

[Updated on: Mon, 20 February 2006 12:59]

Report message to a moderator

Re: how to delete the users name [message #159639 is a reply to message #159636] Mon, 20 February 2006 13:15 Go to previous message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
thank u very much sir
Previous Topic: Creating new user?
Next Topic: Regarding Roles
Goto Forum:
  


Current Time: Thu Mar 28 21:27:24 CDT 2024