OBIEE 11g - Error: "Unauthorized Access : please Contact Administrator." When You Open BI Publisher report from OBIEE Catalog (Doc ID 2151418.1)

Last updated on JULY 12, 2016

Applies to:

Business Intelligence Suite Enterprise Edition - Version to [Release 11g]
Information in this document applies to any platform.


Once you set up External Table Authentication from Initialization Block following Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition - A.1.2 Setting Up External Table Authentication , and Configure BI Publisher to use Oracle BI Server for authentication based on the Fusion Middleware Administrator's Guide for Oracle Business Intelligence Publisher - 5.3.1 Configuring BI Publisher for Oracle BI Server Security , if BI Publisher report is not accessed for a long time, then opening BI Publisher report from OBIEE catalog returns error: "Unauthorized Access : please Contact Administrator." 

Detail steps about setting up External Table Authentication:

1. Create DB user t1 and grant user t1 with DBA privilege.

2. Create table under user t1

create table nq_security

(username varchar2(20)
,pwd varchar2(20)
,display_name varchar2(20)
,log_level number
,grp_name varchar2(200)
,web_group_name varchar2(200)

3. Insert data into the table.

insert into nq_security values ('bi','bi','bi',0,'AuthenticatedUser;BIAdministrator;BIConsumer;BIAuthor','Users');

4. Import the created table to repository physical layer.

5.Create initialization Block like next.


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