以system用户登录: create role name_role; grant select any table to name_role; grant delete any talbe to name_role; grant update any talbe to name_role; ...... grnat name_role to your_user;进入your_user用户; select * from scott.table; delete * from scott.table; .......
以system用户登录: create role name_role; grant select any table to name_role; grant delete any talbe to name_role; grant update any talbe to name_role; ...... grnat name_role to your_user;select * from scott.table; delete * from scott.table; .......
create role name_role;
grant select any table to name_role;
grant delete any talbe to name_role;
grant update any talbe to name_role;
......
grnat name_role to your_user;进入your_user用户;
select * from scott.table;
delete * from scott.table;
.......
create role name_role;
grant select any table to name_role;
grant delete any talbe to name_role;
grant update any talbe to name_role;
......
grnat name_role to your_user;select * from scott.table;
delete * from scott.table;
.......