Question

oracle如何创建一个用户并授予最高权限 并为之分配表空间

用户名 密码 表空间自拟 请告诉我sql语句

Answer 1

create temporary tablespace temp_1 tempfile 'E:\temp_1.dbf' size 20M autoextend on;//在E盘创建20M的表空间
create tablespace ts_1 datafile 'E:\ts_1.dbf' size 20M autoextend on;
create user user1 identified by 111111 default tablespace ts_1 temporary tablespace temp_1;
grant dba to user1;

Answer 2

create tablespace aaa datafile 'd:/oracle/product/10.2.0/oradata/orcl/aaa.dbf' size 100M;
create user bbb identified by bbb default tablespace aaa;
grant dba to bbb;