折雨的天空

新浪微薄腾讯微薄

最新碎语:最近霉到了住。哎。。。

您的位置:折雨的天空 >其他技术> oracle命令行下创建账户

oracle命令行下创建账户

create tablespace you datafile 'E:\app\Administrator\oradata\you\you1.dbf'
size 500M
autoextend on next 100M
maxsize unlimited
logging online permanent;--创建表空间

create user you_user identified by you_user default tablespace fuyou;--创建用户

grant connect,resource to you_user;  
grant create any sequence to you_user;  
grant create any table to you_user;  
grant delete any table to you_user;  
grant insert any table to you_user;  
grant select any table to you_user;  
grant unlimited tablespace to you_user;  
grant execute any procedure to you_user;  
grant update any table to you_user;  
grant create any view to you_user;  
grant dba to you_user;--可以不要这个权限

--授权

多个数据库,多个ORCL的OID切换方式:



set ORACLE_SID=sids1

添加数据文件:

alter tablespace venn add datafile '/opt/oracle/db01/app/oracle/oradata/OSSORCL/venn02.dbf'
size 10M
autoextend on next 100M
maxsize 500M ;


---

转载请注明本文标题和链接:《oracle命令行下创建账户

分享到:

发表评论

路人甲 表情
看不清楚?点图切换