cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 10g Rel 2 - Proxy connection authentication with SAP User ID

Former Member
0 Kudos

Dear Experts,

We are currently doing some research and planning to upgrade SAP R/3 4.6C to ECC 6 and upgrading Oracle from version 9.2 to 10.2

In upgrading to Oracle vers. 10g Rel 2, we got advised that Oracle has apparently introduced a new proxy connection authentication, in which the SAP user ID is given limited privileges (create session only) ??

If you have any information on this or known any impact about this issue, please advise us.

Thanks in advance.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos
Former Member
0 Kudos

Thanks for your help, Kaushal.

I also found the SAP Note 834917 (Oracle Database 10g: New database role SAPCONN and it seems to be on a right direction to cope with that problem.

- For Oracle releases earlier than 10gR2, the CONNECT role includes extensive database authorizations and the more restrictive CONNECT as of 10gR2.

- To overcome this restriction, SAP need to find a way to compensate this, so does it come SAPCONN.

- SAPCONN is the new SAP-specific database role, which is defined to support the normal SAP applications operations (CONNECT, RESOURCE and SELECT_CATALOG_ROLE).

Once again, thanks.