1、TEST_USER1用户在users表空间没有权限,需要给TEST_USER1用户在users表空间分配配额。
TEST_USER1@ORCL>insert into block_edit values (1,'adm');
insert into block_edit values (1,'adm')
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'USERS'
2、进入sys用户
TEST_USER1@ORCL>conn / as sysdba
3、授予权限Connected.
SYS@ORCL>GRANT UNLIMITED TABLESPACE TO test_user1;
4、测试错误是否解决Grant succeeded.
SYS@ORCL>conn test_user1/test
Connected.
TEST_USER1@ORCL>insert into block_edit values (1,'adm');
1 row created.