OraFAQ Forum: Security » how to delete the users name

Home » RDBMS Server » Security » how to delete the users name

Mon, 20 February 2006 12:32

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

Mon, 20 February 2006 12:59

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]

Mon, 20 February 2006 13:15

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: Wed Dec 11 20:01:03 CST 2024