Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Oracle SET ROLE issue

  1. Issue
0
Votes
Undo
  1. Jon Tzeng
    Jon Tzeng
  2. PowerServer
  3. Monday, 17 May 2021 21:04 PM UTC

Hello,

We have long-connection and dynamic connection setting. In our PowerServer 2017 application, Oracle is the database and database user password is used as application password. We use 'SET ROLE ' to set oracle database role to control if user's role after connect to database.

We found there is an issue that after user changes the password (Oracle 'Alter User ' statement), the 'SET ROLE ' is acting strange. It would pick the wrong oracle database role.

What the application processes are

  1. Change password
  2. disconnect sqlca
  3. connect sqlca
  4. Sync the password to other database
  5. set role

It happens on one server but not on the other server. Do you have any suggestions that we my check the setting?

Thanks,

Jon

PowerServer2021 - ODBC connection in end-user PC
Do we need to partition app logic for PowerServer?
Responses (1)
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 18 May 2021 03:28 AM UTC
  2. PowerServer
  3. # 1

Hi Jon,

Please make sure the related configration are the same on both server. You need to restart IIS after changing the settings manually for long connection solution.

You can compare the file below on C:\inetpub\wwwroot\appeon\AEM\config on both servers to check it.
applications.config
connection-cache.config

Regards,
ZhaoKai

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.