About creating user,deleting user and revoke privileges

[kalps]

Hi all,

I have logged on into system/manager and created a user and granted some privileges to that user...now i want to connect with that user...i tried the following command

connect username/password

but after entering this command i am getting an error message as "u r no longer connected to oracle"

how to delete the created user...?

could u tell the solution for this error....

[debasisdas]

Along with the username and password also pass the hoststring
try this

[CODE=oracle]connect username/password@hostst ring[/CODE]
and if u want to delete the user

connect to sys or system or any account which has the required previleges

then try this
[CODE=oracle]
drop user username;[/CODE]
if that has any objects and u still want to drop the user(all the objects will be dropped) then try this

[CODE=oracle]drop user username cascade;[/CODE]