М
Инфаркт миакарда. Вот таклй рубец.
select role#
from defrole$ d,user$ u
where d.user#=:1 and u.user#=d.user# and u.defrole=2 union
select privilege#
from sysauth$ s,user$ u
where (grantee#=:1 or grantee#=1) and privilege#>0 and not exists
(select null
from defrole$
where user#=:1 and role#=s.privilege#) and u.user#=:1 and u.defrole=3
