본문 바로가기

업무/ASIQ

Grant 된 테이블 및 해당테이블 유저찾기

select b.table_name as 대상테이블,
        c.name as 권한부여된ID,
        a.selectauth as SELECT권한여부

from systableperm a , systable b, sysusers c

where a.grantor=459

and a.ttable_id *= b.table_id

and a.grantee *= c.uid

order by b.table_name asc