We created a direct database connection, and it worked fine when tested as Admin. But when I was trying to give a end user access to that report, it kept throwing access denied error:
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 13017] User or group has not been granted the Direct Database Access privilege to access the database 'Oracle Data Warehouse'. Please verify the User/Group Permissions in the Oracle BI Administration Tool. (HY000)
I checked the permissions, and user add access to both:
Edit Direct Database Requests
and
Execute Direct Database Requests
Finally the problem was fixed by making a change in RPD. Do following if you are facing same problem:
-In the physical layer, click on database for which you need to enable direct database query for non-admin users (thats the green cylinder icon).
-Check option - "Allow direct database requests by default"
Thats it. It should work now.
