Oracle SET ROLE issue
- Issue
- Jon Tzeng
- PowerServer
- Monday, 17 May 2021 09: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
- Change password
- disconnect sqlca
- connect sqlca
- Sync the password to other database
- 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
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.