]>
Commit | Line | Data |
---|---|---|
1 | ||
2 | SET @NAME=904; | |
3 | REVOKE ALL PRIVILEGES, GRANT OPTION FROM `6.096`; | |
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; |