> 'USAGE' means that user doesn't have any privileges. Use 'DROP USER'.
I disagree here.
"drop user" will drop the user, revoking "usage" can be something different.
If, for example, you do "grant usage on dbname.*" this is different from
then "just" a user without "usage" granted to that database.
Besides, having a user without privileges might be useful as well :-)
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!