简单权限操作
时间:2010-06-08 来源:gflei
1.改变当前session的schema:
ALTER SESSION SET CURRENT_SCHEMA = alibaba1949
给用户赋需要的权限
select 'grant select,insert,update,delete on stat.' || table_name || ' to mid;' from user_tables;
相关阅读 更多 +
时间:2010-06-08 来源:gflei
1.改变当前session的schema:
ALTER SESSION SET CURRENT_SCHEMA = alibaba1949
给用户赋需要的权限
select 'grant select,insert,update,delete on stat.' || table_name || ' to mid;' from user_tables;