Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[LDAP] 用户更换部门后,所属组织架构还是老部门的 #922

Open
zykgssd opened this issue Feb 15, 2023 · 2 comments
Open

[LDAP] 用户更换部门后,所属组织架构还是老部门的 #922

zykgssd opened this issue Feb 15, 2023 · 2 comments
Labels
Type: bug Something isn't working

Comments

@zykgssd
Copy link

zykgssd commented Feb 15, 2023

蓝鲸和LDAP同步后,一切正常; 某ldap用户更换部门,且在LDAP中删除老部门后; 在蓝鲸用户管理页面(/o/bk_user_manage/organization) 搜索该用户发现它的“组织”还是老部门

版本
V2.4.1

@wklken wklken added the Type: bug Something isn't working label Feb 15, 2023
@wklken
Copy link
Collaborator

wklken commented Feb 22, 2023

# 查这个账号的所有信息
select * from profiles_profile where category_id=x and username=y;
# 拿profile_id

select * from departments_department_profiles where profile_id=x;
# 拿所有department_id

select * from departments_department where id in (); 
# 拿所有部门的id

以上信息脱敏后发下

@zykgssd
Copy link
Author

zykgssd commented Mar 1, 2023

@wklken

拿profile_id

1069

拿所有department_id

+------+---------------+------------+
| id | department_id | profile_id |
+------+---------------+------------+
| 6946 | 888 | 1069 |
+------+---------------+------------+

这个 888 就是老的部门,在页面上通过LDAP账号的级联菜单已经找不到; 但是搜索这个用户,在“组织”中就是显示的 888 这个部门

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Type: bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants