Database level Authentication from OAS

Hello everyone,

 Here's the scenario. We have a OAS 3.0.2 running on top of an 8.0.4 entreprise dabatase. We code everything in PL/SQL using a common schema called PROD.

 Up to now, we had the users connecting at the application level but it is a pain and sort of a security flaw. I now want to move the authentication to the database level but it seems to be causing some problems.

 I have created a role called PROD_USERS which has connection and execute privileges on all packages (using public synonyms) contained in the PROD schema. I have created a DB user for all my users and granted them with PROD_USERS role.

 I've made sure that all the OWA and HT* functions and packages are available to all PROD_USERS through SQL*PLUS. Now, whenever I connect to the DB as someone else than PROD, I cannot execute any of the procedure stored in the PROD schema. Here's the content of the log file:

2606 0 0x400fff `OWS-05101: Execution failed due to Oracle error 6550. [nsebak!test]`

 Any help is appreciated. Oracle Tech Support has been useless so far, as usual. Suggestions from them ranged from Swap space problems to moon phases. Ridiculous, I wonder why we pay them...

 Regards,
 P Received on Tue Aug 31 1999 - 09:24:32 CDT