17,086
社区成员
发帖
与我相关
我的任务
分享
idle> conn / as sysdba
sys@ORCL> grant connect,resource to test identified by test;
sys@ORCL> conn test/test
test@ORCL> create table t (id number);
test@ORCL> conn / as sysdba
sys@ORCL> revoke resource from test;
sys@ORCL> conn test/test
test@ORCL> insert into t values(1);
test@ORCL> drop table t purge;
test@ORCL> create table tt (id number);
create table tt (id number)
*
ERROR at line 1:
ORA-01031: insufficient privileges