This procedure is used in conjunction with NATIVE authentication. For
details about NATIVE authentication, see
You are not allowed to remove the user account of the
If you use this procedure to remove a user account, the schemas and data objects owned by the user remain in the database and can be accessed only by the database owner or by other users who have been granted access to them. If the user is created again, the user regains access to the schemas and data objects.
No result set is returned by this procedure.
If authentication and SQL authorization are both enabled, only the
Drop a user named FRED:
Drop a user named FreD: