SQL Language (MOSC)

MOSC Banner

Insufficient Privileges Issue While Connecting from Java Application

edited Sep 13, 2014 5:01AM in SQL Language (MOSC) 2 commentsAnswered

Hi,

We have table in schema app_admin and application is trying to select data from the table using app_dev user. Application is firing the Oracle select query from inbuilt java code and they are getting the below error saying insufficient privileges. I have checked the grants and synonyms, everything looks good and all are valid.

We are facing the issue only when we call the query from application. When I try to run the same query in SQL*Plus and SQL Developer, it is working fine. Also, when we recreate the synonym and regrant the privileges, application is working fine without any issues. I want to understand why the synonyms/grants are not working when we call it from java and it works when we test it via SQL developer/SQL Plus.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center