Query Table Privilege Drill Through Role Hierarchy

I need a highly optimized query (in EE 8.1.7) to determine if a specific user has a given privilege on a given table. It would be easy except that the table privilege is granted at an unknown level in a hierarchy of roles. Even a simple join of assuming a role depth of 1 takes too long for our needs; walking the role would take far too long.

My other idea is to build a materialized view of users, tables, and privileges with an automatic refresh. Would this work?

Thanks.
dgmorris2_at_airbridge.net Received on Fri Dec 07 2001 - 00:05:27 CST