업무/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
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