BDC view issue

Question

i am trying to connect Oracle using BDC and it works fine [i logged in using Local System Admin] but as soon as i switch to some domain user it gives me this
error.

Unable to connect to [BDC file instance] [For SQL]
You do not have permission to access DB.TableName in OracleInstance [for Oracle]

can some one tell me where i am wrong.

Regards

Answer 1

you are passing credentials directly to oracle
does that user have access to that table in oracle?


The ADF would have been defined with AuthenticationMode PassThrough.

Answer 2

1 - Open your BDC and click on your application.

2 - Now you should be at a page that provides application information.  In the middle of page you will see a link "Manage Permissions" Click it!

3 - The Manage Permissions page.  Click "Add Users/Groupts" link button.

4 - At this point you can enter the desired user.  check the permissions usually Execute and Select in client enough.  If I may suggest, add domainNam\domain users which will give the broadest reach.  You can always change this later. 

5 - One final thing or it will not work.  Check the new user now shown on Manage Permissions List checkbox and click on "Copy all permissions to decendets"  This is important. 

Okay, now login as user you wish to test and checkout the results.  If you already had the browser open with the error close the browser completely and open it again.

Assuming that the user in question already has access to site otherwise that has to be done first.

Good luck!

Answer 3

The error says they cannot access DB.TableName in OracleInstance
That tells me the permission issue resides in the database not the proxy.

Answer 4

Hi Brain

I guess Legna description will do the trick. Will not bet on the fact that error is in DB. The reason: some tools generate the entity name same as the table name. In that case error message might be deceptive. But might be true.

Cheers