Re: Delete a user through SQL.

On Wed, 10 May 2000 21:54:03 GMT,
SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com (Brian Tkatch) wrote:

>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

Forget it, just found it myself.

DROP USER... Brian Received on Wed May 10 2000 - 00:00:00 CDT