Delete a user through SQL.

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com>
Date: 2000/05/10
Message-ID: <3919d96b.31140843@news.alt.net>#1/1

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 Received on Wed May 10 2000 - 00:00:00 CDT