conn system/system;
create user aa identified by aa;
create tablespace tbs datafile 'd:\aq\tbs.dbf' size 3m;
grant create session,create table,create tablespace to aa;
conn aa/aa;
create table stu
(
id int primary key,
name varchar(20)
)
程序如上,运行后,出现表空间在'system'上无权限,请问哪出错了?
create user aa identified by aa;
create tablespace tbs datafile 'd:\aq\tbs.dbf' size 3m;
grant create session,create table,create tablespace to aa;
conn aa/aa;
create table stu
(
id int primary key,
name varchar(20)
)
程序如上,运行后,出现表空间在'system'上无权限,请问哪出错了?
在这一句后面还要加上:
alter user aa default tablespace tbs;
可以加一句:给aa赋dba权限如下:conn system/system;
create user aa identified by aa;
create tablespace tbs datafile 'd:\aq\tbs.dbf' size 3m;
grant create session,create table,create tablespace to aa;
grant dba to aa;
conn aa/aa;
create table stu
(
id int primary key,
name varchar(20)
) 如果你想给aa赋dba的话,那就要给aa指定表空间tbs,这样:
conn system/system;
create tablespace tbs datafile 'd:\aq\tbs.dbf' size 3m;
create user aa identified by aa TABLESPACE tbs;
grant create session,create table,create tablespace to aa;
conn aa/aa;
create table stu
(
id int primary key,
name varchar(20)
)
可以加一句:给aa赋dba权限如下:conn system/system;
create user aa identified by aa;
create tablespace tbs datafile 'd:\aq\tbs.dbf' size 3m;
grant create session,create table,create tablespace to aa;
grant dba to aa;
conn aa/aa;
create table stu
(
id int primary key,
name varchar(20)
) 如果你想给aa赋dba的话,那就要给aa指定表空间tbs,这样:
conn system/system;
create tablespace tbs datafile 'd:\aq\tbs.dbf' size 3m;
create user aa identified by aa TABLESPACE tbs;
grant create session,create table,create tablespace to aa;
conn aa/aa;
create table stu
(
id int primary key,
name varchar(20)
)
alter user aa default tablespace tbs;
alter user aa quota unlimited on tbs;