普通用户以normal身份登录EM的权限
今天数据库普通用户用户HR以normal身份登录EM时，出现如下的错误提示：
经查明是因为缺少权限，查阅有关资料得知，普通用户以normal身份登录EM时需要的权限为：
connect, resource, select_catalog_role
现HR缺少select_catalog_role，以SYS登录数据库，授HR用户select_catalog_role权限
之后HR就可正常登录EM。
|
Error：The application requires more database privileges than you have currently been granted. Click on Help to get more version specific information. |
经查明是因为缺少权限，查阅有关资料得知，普通用户以normal身份登录EM时需要的权限为：
connect, resource, select_catalog_role
现HR缺少select_catalog_role，以SYS登录数据库，授HR用户select_catalog_role权限
点击(此处)折叠或打开
- [oracle@oracle log]$ sqlplus / as sysdba
- SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 8 16:09:10 2015
- Copyright (c) 1982, 2009, Oracle. All rights reserved.
-
Connected to:
-
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
-
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
-
and Real Application Testing options
-
-
SQL> grant select_catalog_role to hr;
-
- Grant succeeded.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29367946/viewspace-1726717/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
