public void delete()
throws SQLException
{
DBConnection connection = db.getConnection();
try {
connection.deleteById(AuthDB.DELETE_ROLE_PERMISSIONS, id);
connection.deleteById(AuthDB.DELETE_USER_ROLES_BY_ROLE, id);
connection.deleteById(AuthDB.DELETE_GROUP_ROLES_BY_ROLE, id);
connection.deleteById(AuthDB.DELETE_ROLE, id);
db.realmGroupCaches.clear();
db.roleCache.remove(id);