先建立表空间,然后建立用户。
create table tablespace_name datafile '/oradata/a.dat' size 500m;create user user_name identified by user_name user_name default tablespace tablespace_name temporary tablespace temp ;
grant dba, connect, resource, create table to user_name ;
create table tablespace_name datafile '/oradata/a.dat' size 500m;create user user_name identified by user_name user_name default tablespace tablespace_name temporary tablespace temp ;
grant dba, connect, resource, create table to user_name ;
解决方案 »
- 求助:impdp导入数据报错!
- oracle enterprise manager数据库连接用户密码出错
- Oracle 的Database Control URL 问题
- 做一个备份程序 如果备份库空间不足报什么错?
- 急!高手给看看吧!!!!解决给分!
- 只有ORADATA目录。请问怎样恢复数据?
- Oracle按地区分区建表后,当同时对不同分区进行批量update时,是否会锁表?
- 跪求9i或更高的下载!
- ★★有个关于group by分组的SQL向高手请教
- plsql在服务器上导出dmp文件出现如图所示错误!!!
- 存储过程中字符组合的问题,急急,在线等
- 请问把password设置成过期状态有什么用?
create user TESTUSER
identified by ""
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to TESTUSER with admin option;
grant dba to TESTUSER with admin option;
grant resource to TESTUSER with admin option;
-- Grant/Revoke system privileges
grant unlimited tablespace to TESTUSER with admin option;