Print Thread
Can't unlock Report
#65032 11/10/23 03:04 PM
Joined: Feb 2003
Posts: 17
K
khang Offline OP
Member
OP Offline
Member
K
Joined: Feb 2003
Posts: 17
Hello,
I with some locked report, when I click now on the unlock button, nothing happen. I d'ont even have the password dialog.
But if I try to execute the reports, it works as usual.
What tricks do I miss as I need to retrieve the original SQL.

Re: Can't unlock Report
khang #65042 11/13/23 09:33 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
This report is probably only unlocked when connected as the user from the report options.


Marco Kalter
Allround Automations
Re: Can't unlock Report
Marco Kalter #65055 11/14/23 02:47 PM
Joined: Feb 2003
Posts: 17
K
khang Offline OP
Member
OP Offline
Member
K
Joined: Feb 2003
Posts: 17
Is there a way to know who is the user in report options ?

Re: Can't unlock Report
khang #65060 11/15/23 09:28 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
No, this information is unfortunately not visible. You can only view or edit the report definition when connected with the user from the report definition.


Marco Kalter
Allround Automations
Re: Can't unlock Report
khang #65076 11/16/23 04:24 PM
Joined: Apr 2003
Posts: 517
Portland, OR, USA
M
Member
Offline
Member
M
Joined: Apr 2003
Posts: 517
Portland, OR, USA
If you are just needing the original SQL, I found the reports in %APPDATA%/PLSQL Developer Common. Then I can open it with a text editor and the SQL is there.

Last edited by mike; 11/16/23 04:31 PM.

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.094s Queries: 15 (0.021s) Memory: 2.5109 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-04-29 16:50:32 UTC
Valid HTML 5 and Valid CSS