select, insert, update, delete on 表名 to 被授权用户名;
select 'grant select, insert, update, delete on '||t.tname||' to 被授权用户名;' from tab t where t.tabtype = 'TABLE';
select on 序列名 to 被授权用户名;
select 'grant select on '||t.sequence_name||' to 被授权用户名;' from sys.dba_sequences t where sequence_owner = '授权用户名(大写)';