APEX

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!

Authorization Scheme -- Best Practices?

482478Feb 27 2008 — edited Feb 28 2008

Hi All --

We have a reporting application containing approximately 300 pages and 60 or so menu items all using authorization schemes (exists SQL method) as a means to determine whether or not a use can see the menu items and/or access the pages. We've been seeing an issue where a user logging into the application experiences poor performance upon login and have traced it to our access checks and the number of "exists" queries run when a user logs in and before our menu is displayed.

What would be considered best practice in a case such as this? Does anyone have any ideas on how to increase the performance on these authorizaton checks?

Thanks,
Leigh Johnson
Fastenal Company

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 27 2008

Added on Feb 27 2008

#apex-discussions

32 comments

2,378 views