OBIEE Direct Database request not working

Question

Hi,

I am getting the following error when I execute a Direct Database Request:

I have given proper permissions under: Administration/Manage Privileges but to no avail, Any ideas?

BTW, It works fine when I login as Administrator

Version: OBIEE 12.2.1.3

Gianni Ceresa · Answer

Great it worked. Luckily you have this double security allowing you to really pick who can query which source as otherwise it would be too open.

So you can close the thread

KashSidd · Answer

Here is what I had to do:

Open your repository in the Administration Tool to access the query limits functionality for an application role.

Select Manage, then select Identity.

In the Identity Manager dialog, in the tree pane, select BI Repository.

In the right pane, select the Application Roles tab, then double-click the application role for which you want to grant privs

In the Application Role dialog, click Permissions.

In the User/Application Role Permissions dialog, click the Query Limits tab.

In the Query Limits tab for each database object, in the Execute Direct Database Requests field, select an option.

Click OK, then click OK again to return to the Identity Manager.

KashSidd · Answer

Thanks a bunch and I got it working by following your instructions