Skip to Main Content
Forums

SQL Developer

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!

reports and Diagnostics pack

CMARApr 1 2022 — edited Apr 1 2022

Good day,
trying to use two reports, which i am fairly sure i have used in the past
Blocking Locks by User
Active Session
however both are now triggering a pop up saying that to run them i need to have a Diagnostic Pack licensed.
is this correct behavior ? I'm fairly sure the SQL that these reports run doesn't require any Diagnostics pack procedures, but can someone confirm?
running SQL Dev 19.2
This post has been answered by thatJeffSmith-Oracle on Apr 1 2022
Jump to Answer

Comments

Create a custom authentication process and check for the entry in your custom table for that user.

van Baal HR
Answer

That is just what I did. I have created a separate package with a function and a procedure in it, that uses the user defined table to select the user data from. Then I changed the code behind the login process to call for the newly created package. I have pretty much used the concept posed here: http://o7planning.org/en/10443/custom-authentication-in-oracle-apex#a1349999

Marked as Answer by van Baal HR · Sep 27 2020
1 - 2

Post Details

Added on Apr 1 2022
#report, #sql-developer
2 comments
99 views