My Oracle Support Banner

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

Last updated on AUGUST 16, 2019

Applies to:

Oracle Argus Insight - Version 5.0.3.3 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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.