We have an issue with Direct database request
while creating a report. The below is the issue.
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 ‘YOUR CONNECTION POOL’. Please verify the User/Group Permissions in the Oracle BI Administration Tool. (HY000)
Solution
In Presentation Services->Settings->Administrations->Manage Privilege" have given
permission to "Execute Direct Database Requests" for user or Group.
AND Mandatory to give an access in RPD.
Open OBIEE Administrative tool click on Manage->security->user or Group
Double click on the user or group who needs to have the execute direct database request permission.Select "allow" from the drop down list in the query limits block to the respective connection pool.
Double click on the user or group who needs to have the execute direct database request permission.Select "allow" from the drop down list in the query limits block to the respective connection pool.
Hope this will resolve your issue.
Hi,
ReplyDeleteWhat is the use DDR in OBIEE. When do we need this ?
Does DDR decreases the Performance ?
I’m Артур Борис a resident/citizen of the Republic Of Russian. I’m 52 years of age, an entrepreneur/businessman. I once had difficulties in financing my project/business, if not for a good friend of mine who introduced me to Mr Benjamin Lee to get a loan worth $250,000 USD from his company. When i contacted them it took just five working days to get my loan process done and transferred to my account. Even with a bad credit history, they still offer their service to you. They also offer all kinds of loan such as business loans, home loans, personal loans, car loans. I don’t know how to thank them for what they have done for me but God will reward them according to his riches in glory. If you need an urgent financial assistance contact them today via email lfdsloans@outlook.com WhatsApp information...+1-989-394-3740
ReplyDelete