Create Oracle Database tablespaces, roles, and user SQL statements

1. Create a role

Create role "qiudingrole" not identified;

Grant "Connect" to "qiudingrole ";
Grant "dba" to "qiudingrole ";
Grant "resource" to "qiudingrole ";

2. Create a tablespace
Create smallfile tablespace "diaocha" datafile 'd: \ oracle \ product \ 10.1.0 \ oradata \ qiuding \ diaocha 'size 100 m autoextend on next 1 m maxsize unlimited logging extent management local segment space management auto;

Begin dbms_server_alert.set_threshold (9000, null, 1, 1, null, 5, 'diaocha '); end;

Create smallfile temporary tablespace "diaocha_temp" tempfile 'd: \ oracle \ product \ 10.1.0 \ oradata \ qiuding \ diaocha_temp 'size 100 m autoextend on next 1 m maxsize unlimited extent management local uniform size 1 m;

Begin dbms_server_alert.set_threshold (9000, null, 5, 'diaocha _ temp '); end;

3. Create a user
Create user qiuding
Identified by "qiuding"
Default tablespace "diaocha"
Temporary tablespace "diaocha_temp"
Profile default
Account unlock;

Grant qiudingrole to qiuding;
Grant unlimited tablespace to qiuding

4. Create a backup directory and grant corresponding Permissions
Create directory dump_dir as 'd: \ oracle \ backup ';
Grant read, write on directory dump_dir to qiuding;

 

Turn: http://www.blogjava.net/lyjjq/articles/99167.html