업무/ASIQ

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

새벽여행 2006. 12. 11. 19:09
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