create user new_user identified by new_user;
grant connect to new_user;grant select on user_1.table_3 to new_user;
grant update on user_1.table_3 to new_user;
grant delete on user_1.table_3 to new_user;
grant insert on user_1.table_3 to new_user;grant select on user_1.table_4 to new_user;
grant update on user_1.table_4 to new_user;
grant delete on user_1.table_4 to new_user;
grant insert on user_1.table_4 to new_user;
grant connect to new_user;grant select on user_1.table_3 to new_user;
grant update on user_1.table_3 to new_user;
grant delete on user_1.table_3 to new_user;
grant insert on user_1.table_3 to new_user;grant select on user_1.table_4 to new_user;
grant update on user_1.table_4 to new_user;
grant delete on user_1.table_4 to new_user;
grant insert on user_1.table_4 to new_user;
解决方案 »
- 面试题看看你能答对多少3
- SQL问题,麻烦大家指点下谢谢
- 揭开CDP面纱!
- 跨服务器操作数据库
- linux6.3安装oracle11g的时候提示如下错误,是什么原因,谢谢
- 请高手指教--数据库开发设计与底层知识
- to_date('2002-01-14 16:34:34','YYYY-MM-DD hh:mi:ss'),显示 ORA-01849: 小时值必须介于 1 和 12 之间 ,如何解决呀?
- 存储过程中的取值问题?
- oracle9i配置问题 在线等
- 求sql语句:查询一张表中 某一字段值重复的次数
- 请问oic编程 是不是不需要安装客户端??
- 请问在SQL里的top 1在Oracle怎么实现呢?急急急!!
grant select,delete,update,insert on user_1.table_3 to new_user;
grant select,delete,update,insert on user_1.table_4 to new_user;
revoke select,delete,update,insert on user_1.table_3 from new_user;