Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

session time out with 'set role' command

717896May 12 2010 — edited May 12 2010
Hello, I have a issue really can't figure it out. Please help me!

My company has a asp.net application. It sets user session timeout to 15 min. All the login users have 1 default role 'connect' and 1 nodefault role 'new_role' with 'set role' command. The roles are stored in Oracle DB. My issue is:

1. when user login and navigates in system, everything works well. But if user leave system idle for about 8 min, then his connection is gone. (I checked from session view).
2. If I change 'new_role' to default role, this issue will not happen and session will time out in 15 min as we set in application side.

Could anyone give me some clue? Why 'set role' is a matter?

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2010
Added on May 12 2010
11 comments
1,581 views