我在一个816的系统里,想创建一个只能联接和查询(不能修改和创建)本用户下的对像的用户,代码如下:
drop role connect_soft ;
create role connect_soft ;
grant create session to connect_soft ;
dropuser soft cascade;
create user soft identified by soft
DEFAULT TABLESPACE data
TEMPORARY TABLESPACE temp
QUOTA UNLIMITED ON system
QUOTA UNLIMITED ON temp
QUOTA UNLIMITED ON rbsg
QUOTA UNLIMITED ON data
QUOTA UNLIMITED ON indx ;
GRANT connect_softto soft;
connect soft/soft@soft_db;
create table a_b (a char(10));
Table created
同样的代码在817下,
connect soft/soft@soft_db;
create table a_b (a char(10));
ORA-01031: insufficient privileges
这才是我想要的结果,为什么会这样啊?????