Pau Lo
asked on
filter out users based on permissions
i have received an xlsx file of users and their corresponding security roles for an application. one of the roles is called disabled. If they have that role they cannot access the system. However a user can have many roles, e.g
user 1 - disabled
user 1 - HR read access
user 1 - payroll read access
what I need is away of filtering the list, to only show users who do not have the disabled role, and just create a filtered list of active accounts and which roles they do have. user name is column A, and the role name is column C. Is there an easy way to acheive this. e.g. if original data was this
user 1 - disabled
user 1 - HR read access
user 1 - payroll read access
user 2 - HR read access
user 2 - HR admin access
user 3 - disabled
user 3 - HR read access
one filtered would only return
user 2 - HR read access
user 2 - HR admin access
as that is the only user without the disabled role
user 1 - disabled
user 1 - HR read access
user 1 - payroll read access
what I need is away of filtering the list, to only show users who do not have the disabled role, and just create a filtered list of active accounts and which roles they do have. user name is column A, and the role name is column C. Is there an easy way to acheive this. e.g. if original data was this
user 1 - disabled
user 1 - HR read access
user 1 - payroll read access
user 2 - HR read access
user 2 - HR admin access
user 3 - disabled
user 3 - HR read access
one filtered would only return
user 2 - HR read access
user 2 - HR admin access
as that is the only user without the disabled role
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Roy Cox
My suggestion is automatic, if you can specify a variety of conditions, if you do not want text containing disabled then choose "does not contain"
No comment has been added to this question in more than 14 days, so it is now classified as abandoned.
I have recommended this question be closed as follows:
Split: Shums (ID: 42070303) and Roy Cox (ID: 42070248)
If you feel this question should be closed differently, post an objection and a moderator will read all objections and then close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
I have recommended this question be closed as follows:
Split: Shums (ID: 42070303) and Roy Cox (ID: 42070248)
If you feel this question should be closed differently, post an objection and a moderator will read all objections and then close it as they feel fit. If no one objects, this question will be closed automatically the way described above.