I've defined an Oracle library using the Library Manager. The library isn't pre-assigned. It's a first shot using the technology so I've pretty much followed instructions (ie, created db schema, set the default login, imported tables).
I've created a stored process from an EG process flow which uses this library. When I run the report using the MS Add-in via MS Word I'm getting this error:
It seems to be picking up my userid/pw from logging into the server, and not the assigned Oracle user credentials. I can see this when creating the stored process in EG, but can't figure out why. Any ideas??
My initial post isn't quite right. What's happening is ANY user who tries to run this stored process via the MS Add-in will get the same error containing MY username in the USERID field. It's not a problem with the Oracle data, but authenticating to the metadata related to the Oracle library. I'm set up as an admin in adminUsers.txt (without the asterick), and I thought that may have something to do with my personal userid being attached to this libname. Removing my name from adminUsers.txt and refreshing my servers didn't solve it.
I recently changed my password which leads me to think that somewhere in my setup my initial userid/pw was somehow stored. Still baffled...