ResourcePermission Table Purge

[Yaz Erkan, geändert vor 6 Jahren.]

Hi,

I'm currently profiling our application, and I'm seeing a significant number of queries going against ResourcePermission table. On production we have 150,000 records in this table. Is there a way to remove the data related to old/deleted users and portlets?

Thank you,
Have a great weekend.

[David H Nebinger, geändert vor 6 Jahren.]

Yaz Erkan:

Is there a way to remove the data related to old/deleted users and portlets?

Permissions are tied to resources, but there are no direct user references in the table. Remember everything is RBAC, so a user has a role and a role has permissions.

Portlets may be a different story, but it is not likely that a huge number of your 150k rows are from a large number of undeployed portlets.

Your best bet is to run explains on the queries you're seeing and verify that, for example, they are doing index lookups instead of full table scans.

Also you're going to want to ensure you're using the latest permissions algorithm, 6, as that has been tuned to use more bitwise permission checks.







Come meet me at the 2017 LSNA!

[Yaz Erkan, geändert vor 6 Jahren.]

David,

Thanks for taking the time to respond.
I don't see these queries in the database. I'm profiling at the app server level, so those are the queries that the app sends to the database.
I'll do some more investigation.

Thanks again.