点击(此处)折叠或打开
-
create user wangym identified by \"wangym\";
-
-
grant create session to wangym;
-
grant create table to wangym;
-
grant create tablespace to wangym;
-
grant create view to wangym;
-
-
create tablespace demo_tbs
-
datafile \'/home/oracle/oradata/demo_tbs.dbf\'
-
size 1500M
-
autoextend on next 5M maxsize 3000M;
-
-
alter user wangym quota unlimited on demo_tbs;
-
-
grant connect,resource to wangym;
-
grant create any sequence to wangym;
-
grant create any table to wangym;
-
grant delete any table to wangym;
-
grant insert any table to wangym;
-
grant select any table to wangym;
-
grant unlimited tablespace to wangym;
-
grant execute any procedure to wangym;
-
grant update any table to wangym;
- grant create any view to wangym;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29830651/viewspace-1338617/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
win7下mongoDB安装及连接
下一篇：
关于NLS_DATE_FORMAT
请登录后发表评论
登录
全部评论
