Argus Insight Patch 5.0.3.3 Errors When Creating Ai_readonly_user (Doc ID 1357463.1)

Last updated on SEPTEMBER 14, 2011

Applies to:

Oracle Argus Insight - Version: 5.0.3.3 and later   [Release: 5.0 and later ]
Information in this document applies to any platform.

Symptoms

Creating the ai_argus_read_only[grant].sql with errors when running ai_argus_read_only_user_setup.bat file:


Last portion of the ai_argus_read_only[grant].sql file:

prompt -- Granting Privileges on 'ARGUS_APP','ESM_OWNER','ARGUS_APP','ARGUS_APP' Views to INSIGHT_READONLY_ROLE Completed
----------------------------------------------------------------------------------------------------
prompt -- Granting additional Privileges on ARGUS_APP Tables and Views to INSIGHT_READONLY_ROLE
-------------------------------------------------------------------------------------------------------------
---
---
GRANT INSERT,UPDATE,DELETE ON ARGUS_APP.V$CFG_USERS_PASSHIST TO INSIGHT_READONLY_ROLE ;
GRANT INSERT,UPDATE,DELETE ON ARGUS_APP.V$CFG_USERS TO INSIGHT_READONLY_ROLE ;
declare
*
ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 100000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 32
ORA-06512: at "SYS.DBMS_OUTPUT", line 97
ORA-06512: at "SYS.DBMS_OUTPUT", line 112
ORA-06512: at line 200

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms