Query involving roles and privs.
577917Dec 17 2010 — edited Dec 17 2010I am trying to create the following query:
Given a table (or view) and a user, I would like the query to list all paths of roles through which the user has been granted given privilege (say "SELECT") to the selected table. The paths will look someting like
TABLE => ROLE1 => ROLE2 => ROLE3 => USER
If the user doesn't have SELECT privilege on the table than the query will return no rows ofcourse. If there is more than one path through which the user gets the privilege, then the query will return multiple rows.
Can anybody assist please
George