作者:随遇而安gqS1 | 来源:互联网 | 2023-10-12 15:37
我在用数据泵导入数据的时候报的错TEST_USER1@ORCLconnassysdbaSYS@ORCLgrantplustracetoTEST_USER1;grantplust
我在用数据泵导入数据的时候报的错
TEST_USER1@ORCL> conn / as sysdba
SYS@ORCL> grant plustrace to TEST_USER1;
grant plustrace to TEST_USER1
*
ERROR at line 1:
ORA-01919: role ‘PLUSTRACE’ does not exist
SYS@ORCL> select * from dba_roles where role=’PLUSTRACE’;
no rows selected
2、 建立角色
SYS@ORCL>@?/sqlplus/admin/plustrce.sql –以下内容自动执行
SQL>
SQL> drop role plustrace;
drop role plustrace
*
ERROR at line 1:
ORA-01919: role ‘PLUSTRACE’ does not exist
SQL> create role plustrace;
Role created.
SQL>
SQL> grant select on v_$sesstat to plustrace;
Grant succeeded.
SQL> grant select on v_$statname to plustrace;
Grant succeeded.
SQL> grant select on v_$mystat to plustrace;
Grant succeeded.
3. 赋予权限
SQL> grant plustrace to dba with admin option;
Grant succeeded.
4.进行查看
SQL> select * from dba_roles where role=’PLUSTRACE’;
ROLE PASSWORD AUTHENTICAT
—————————— ——– ———–
PLUSTRACE NO NONE