AQ_ADMINISTRATOR_ROLE

要使用 DBA Management Pack 应用程序,必须已被授予 SELECT_CATALOG_ROLE。

要在 Oracle8 之前的 Oracle 数据库上创建 SELECT_CATALOG_ROLE,请运行 dbaprcre.sql 脚本。该脚本必须以 SYS 权限运行,允许具有 OEM_DEVELOPER_ROLE 的用户使用 Oracle 工具。

对于任何版本的数据库,您都应该能够运行该脚本,并将该新角色分配给任一用户。

dbaprcre.sql 脚本

create role "OEM_DEVELOPER_ROLE" not identified;

grant "SELECT_CATALOG_ROLE" to "OEM_DEVELOPER_ROLE";

grant CREATE TYPE to "OEM_DEVELOPER_ROLE";

grant "AQ_ADMINISTRATOR_ROLE" to "OEM_DEVELOPER_ROLE";

grant SELECT ON "SYS"."OBJ$" to "OEM_DEVELOPER_ROLE";

grant SELECT ON "SYS"."USER$" to "OEM_DEVELOPER_ROLE";

grant SELECT ON "SYS"."CDEF$" to "OEM_DEVELOPER_ROLE";

grant SELECT ON "SYS"."SEG$" to "OEM_DEVELOPER_ROLE";

grant SELECT ON "SYS"."IND$" to "OEM_DEVELOPER_ROLE";

grant SELECT ON "SYS"."METHOD$" to "OEM_DEVELOPER_ROLE";

grant SELECT ON "SYS"."TAB$" to "OEM_DEVELOPER_ROLE";

grant SELECT ON "SYS"."TYPE$" to "OEM_DEVELOPER_ROLE";

grant SELECT ON "SYS"."FILEXT$" to "OEM_DEVELOPER_ROLE";

select decode(user, 'SYS', 'Success', 'This script needs to be run as sys!') Status from dual;