GRANT SELECT ON A.table TO B;
GRANT INSERT ON A.table TO B;
GRANT UPDATE ON A.table TO B;
GRANT DELETE ON A.table TO B;
对多张表操作:
select 'grant select on '||table_name||' to usr2' from user_tables;
GRANT SELECT ON A.table TO B;
GRANT INSERT ON A.table TO B;
GRANT UPDATE ON A.table TO B;
GRANT DELETE ON A.table TO B;
对多张表操作:
select 'grant select on '||table_name||' to usr2' from user_tables;