19 lines
603 B
SQL
19 lines
603 B
SQL
DELETE casbin
|
|
FROM sys_casbin_rule casbin
|
|
JOIN sys_api api
|
|
ON casbin.ptype = 'p'
|
|
AND casbin.v0 = 'chorus_operator'
|
|
AND casbin.v1 = api.path
|
|
AND casbin.v2 = api.action
|
|
WHERE api.handle IN ('chorus.users.create', 'chorus.users.password.reset');
|
|
|
|
DELETE menu_api
|
|
FROM sys_menu_api_rule menu_api
|
|
JOIN sys_api api ON api.id = menu_api.sys_api_id
|
|
JOIN sys_menu menu ON menu.menu_id = menu_api.menu_id
|
|
WHERE menu.path = '/chorus/users'
|
|
AND api.handle IN ('chorus.users.create', 'chorus.users.password.reset');
|
|
|
|
DELETE FROM sys_api
|
|
WHERE handle IN ('chorus.users.create', 'chorus.users.password.reset');
|