Home » SQL & PL/SQL » SQL & PL/SQL » URGENT !!! drop a user ???
URGENT !!! drop a user ??? [message #2163] Tue, 25 June 2002 05:16 Go to next message
ron
Messages: 50
Registered: July 1999
Member
I signed in sys account....and i need to drop this user with all the tables created by him.....i gave the command : DROP USER <USERNAME> CASCADE;...

it says " can't drop the when already logged in".....

As far as i know....this user is not logged in...

My question is...

" How do i forcebly drop this user....basically kick him out ?"

any help is appreciated...

Report message to a moderator

Re: URGENT !!! drop a user ??? [message #2165 is a reply to message #2163] Tue, 25 June 2002 08:12 Go to previous message
7
Messages: 2
Registered: June 2002
Junior Member
DROP USER idiot CASCADE;

9i only

Report message to a moderator

Previous Topic: windowing function
Next Topic: Session killing automatically
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 11:12:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.