Direct Database Connection error

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.