数据表，视图授权脚本

cjt

可能对一些人有帮助


database db_name;
unload to revoke_a.sql
delimiter ';'
select "revoke all on "||tabname||
" from user01,user02,user03"
from systables where tabid>;100
and tabtype='T';

unload to revoke_a_V.sql
delimiter ';'
select "revoke all on "||tabname||
" from user01,user02,user03"
from systables where tabid>;100
and tabtype='V';

unload to grant_a.sql
delimiter ';'
select "grant select,update,insert,delete on "||tabname||
" to user01,user02,user03"
from systables where tabid>;100
and tabtype='T';

unload to grant_a_v.sql
delimiter ';'
select "grant select,update,insert,delete on "||tabname||
" to user01,user02,user03"
from systables where tabid>;100
and tabtype='V';