lplus /nolog
conn system/1234@orcl
create tablespace aries logging datafile ‘e:\oracle\oradata\orcl\aries.dbf‘ size 32m autoextend on next 32m maxsize 2048m extent management local;
create user survey identified by 1234 default tablespace aries;
grant connect,resource to survey;
grant create session, create any table, create any view ,create any index, create any procedure,alter any table, alter any procedure,drop any table, drop any view, drop any index, drop any procedure,select any table, insert any table, update any table, delete any table to survey;
oracle 创建用户模板
标签:taf insert default file log roc creat update 模板
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉
本文系统来源:http://www.cnblogs.com/Interface123/p/7291401.html