ORA-01919: role 'PLUSTRACE' does not exist
来源:互联网 发布:腾讯视频网络电影合作 编辑:程序博客网 时间:2024/05/16 12:30
1、授予用户 plustrace 角色,出现ORA-01919错误报角色不存在
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 --以下内容自动执行
3、授予用户 plustrace 角色SYS@ORCL>
SYS@ORCL>drop role plustrace;
drop role plustrace
*
ERROR at line 1:
ORA-01919: role 'PLUSTRACE' does not exist
SYS@ORCL>create role plustrace;
Role created.
SYS@ORCL>
SYS@ORCL>grant select on v_$sesstat to plustrace;
Grant succeeded.
SYS@ORCL>grant select on v_$statname to plustrace;
Grant succeeded.
SYS@ORCL>grant select on v_$mystat to plustrace;
Grant succeeded.
SYS@ORCL>grant plustrace to dba with admin option;
Grant succeeded.
SYS@ORCL>
SYS@ORCL>set echo off
SYS@ORCL> grant plustrace to TEST_USER1;
Grant succeeded.
0 0
- ORA-01919: role 'PLUSTRACE' does not exist
- role 'PLUSTRACE' does not exist
- psql FATAL role vagrant does not exist
- psql: FATAL: role “username” does not exist
- psql: FATAL: role “postgres” does not exist 解决方案
- com.edb.util.PSQLException: FATAL: role "主机名" does not exist
- navicat连接postgresql出现 role "postgresql" does not exist
- Hibernate: ORA-02289: sequence does not exist
- ORA-29807: specified operator does not exist
- ORA-00959: tablespace 'PSAPTEMP' does not exist
- ORA-00959: tablespace '' does not exist
- ORA-04043 object DROP_AW_ELIST_ALL does not exist
- 【ORA】ORA-00030: User session ID does not exist.
- ORA-00942:table or view does not exist
- ORA-00942: table or view does not exist
- ORA-27101: shared memory realm does not exist 一种解决方案
- ORA-00942:table or view does not exist
- ORA-27101: shared memory realm does not exist
- hello world!
- 网站导航如何SEO优化?
- android.view.WindowManager$BadTokenException: Unable to add window -- token android.os.BinderProxy@4
- Telephony之进程与实体(原)
- 面试简答题(2)
- ORA-01919: role 'PLUSTRACE' does not exist
- Tomcat ClassLoader研究
- S5PV210--1---210启动方式和代码前16字节
- js开发利器
- 代码分析 Asterisk11.5.0
- jQuery Mobile入门
- c# where(泛型类型约束)
- jquery的$.extend和$.fn.extend作用及区别
- CGFloat和float的区别及案例分析