[sql-web.git] / contrib / deleteuser.sql


SET @NAME=904;
REVOKE ALL PRIVILEGES, GRANT OPTION FROM `6.096`;

USE mitsql;
DELETE FROM DBQuota WHERE DatabaseId IN (SELECT DatabaseId FROM DBOwner WHERE UserId = @NAME);
DELETE FROM DB WHERE DatabaseId IN (SELECT DatabaseId FROM DBOwner WHERE UserId = @NAME);
DELETE FROM DBOwner WHERE UserId = @NAME;
DELETE FROM UserGroup WHERE UserId = @NAME;
DELETE FROM UserQuota WHERE UserId = @NAME;
DELETE FROM UserStat WHERE UserId = @NAME;
DELETE FROM `User` WHERE UserId = @NAME;
Commit	Line	Data
78719756	1
8835695c JP	2	SET @NAME=904;
8835695c JP	3	REVOKE ALL PRIVILEGES, GRANT OPTION FROM `6.096`;
78719756 JP	4
	5	USE mitsql;
	6	DELETE FROM DBQuota WHERE DatabaseId IN (SELECT DatabaseId FROM DBOwner WHERE UserId = @NAME);
	7	DELETE FROM DB WHERE DatabaseId IN (SELECT DatabaseId FROM DBOwner WHERE UserId = @NAME);
	8	DELETE FROM DBOwner WHERE UserId = @NAME;
	9	DELETE FROM UserGroup WHERE UserId = @NAME;
	10	DELETE FROM UserQuota WHERE UserId = @NAME;
	11	DELETE FROM UserStat WHERE UserId = @NAME;
	12	DELETE FROM `User` WHERE UserId = @NAME;