He has found that the roles are loaded with the following query:
select /*+ connect_by_filtering */ privilege#,level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0;Thus it seems as the the order may be random, though it is possible that usually the data is returned in the order of insertion.
No comments:
Post a Comment