User with user_admin role cannot view all records in the list view

MR1
Tera Contributor

‎08-28-2023 08:35 AM

Hi All,

 

The user with user_admin role cannot view all records in the list view of sys_user table. 

User with user_admin role needs to access and modify all records on the user table. I reviewed all the ACL and BR but didn't help.

 

Thanks

Labels:
0 Helpfuls
  • 280 Views
2 REPLIES 2

Sandeep Rajput
Tera Patron
Tera Patron

‎08-28-2023 08:50 AM

@MR1 Use the ACL debugger and check if any read ACLs for user with user_admin role are failing. Also, what message do you see when you impersonate with user having user_admin role, does it show some rows are hidden due to security rules message? or there is simply no message at all and the records are missing. If it is the later, then you can suspect the involvement of a query BR here.

0 Helpfuls

MR1
Tera Contributor
In response to Sandeep Rajput

‎08-28-2023 08:53 AM

@Sandeep Rajput  - Thanks for your response!

I already debugged the ACL and BRs. I don't see any message on the list view of user table.

But when they tried to do a search by name then user with user_admin role can view and open the view records.

 

Thanks

0 Helpfuls