SYSCS_UTIL.SYSCS_DROP_USER system procedure removes a user account
from a database.
This procedure is used in conjunction with NATIVE authentication..
You are not allowed to remove the user account of the database owner.
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, then he or she regains access to the schemas and data objects.
SYSCS_UTIL.SYSCS_DROP_USER( IN userName VARCHAR(128) )
A user name that is case-sensitive if you place the name string in double quotes. This user name is an authorization identifier. If the user name is that of the database owner, an error is raised.
This procedure does not return a result.
If authentication and SQL authorization are both enabled, only the database owner has execute privileges on this function by default. The database owner can grant access to other users.
Drop a user named FRED:
CallableStatement cs = conn.prepareCall ("CALL SYSCS_UTIL.SYSCS_DROP_USER('fred')"); cs.execute(); cs.close();
Drop a user named FreD:
splice> CALL SYSCS_UTIL.SYSCS_DROP_USER('fred'); Statement executed;