Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Delete a user through SQL.
Le mer, 10 mai 2000, Brian Tkatch a écrit :
>I can create a user
>
>GRANT CONNECT TO Moo IDENTIFIED By Cow;
>
>I can also
>
>REVOKE CONNECT FROM Moo;
>
>And that prevent the user from doing anything but does not remove the
>user. The user still shows up in security manager, and although that
>user cannot logon, the password is stil checked. That is, with the
>wrong pasword the error is bad password, with the correct password the
>error is does not hace create session proviledges.
>
>How do I delete the user completely via SQL?
>
>Brian
You can try
drop user cascade
Philippe.
Received on Thu May 11 2000 - 00:00:00 CDT