【Oracle】创建用户及设定权限

create user ufo identified by 1234;
grant create session to ufo;
grant create tablespace to ufo; 
grant create table to ufo;
grant drop any table to ufo;
grant insert any table to ufo;
grant update any table to ufo;
grant all privileges to ufo;
grant dba to ufo;
create tablespace test datafile 'D:\app\horn1\oradata\test.txt' size 10m;

 

参考资料:

https://www.iteye.com/blog/1084647490-2255426

--END-- 2019年11月9日15:30:49

posted @ 2019-11-09 15:31  逆火狂飙  阅读(389)  评论(1编辑  收藏  举报
生当作人杰 死亦为鬼雄 至今思项羽 不肯过江东