Re: Query Table Privilege Drill Through Role Hierarchy

How about

• starting with all grantees that have access to the table
• calling a procedure with each of the grantees, which checks if this grantee is a role,
  • if no: list and stop,
  • if yes: determine the grantees that have been grated the role, and call the procedure recursively with each of the grantees

Jaap.

On Fri, 07 Dec 2001 06:05:27 GMT, "Richard Pike" <rpike33_at_mediaone.net> wrote:

>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 Wed Dec 19 2001 - 12:30:59 CST