Re: Delete a user through SQL.

Drop User Moo cascading delete;
Kills the User and all its objects.

Cheers,

    Thomas

BLANC Philippe schrieb:

> 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 Fri May 26 2000 - 00:00:00 CDT